skip to main | skip to sidebar

my notes on Java ,J2EE,Struts, EJB, Spring, AJAX

Thursday, June 12, 2008

Problem facing with SQL Query, ORA-01425: escape character must be character string of length 1

select product_id from in_prod_qry_gtv where full_desc
like '%' || 'ALEX\\%DIAMOND\\%' || '%' escape '\\'


solutio i got when i googled is that "Change it to a character string of length 1."
but , still it is not resolving my problem.
Posted by java books at 2:43 AM
Labels: 1, character, escape, length, oraerror, string

No comments:

Post a Comment

Newer Post Home
Subscribe to: Post Comments (Atom)

Enter your email address:

Delivered by FeedBurner

Blog Archive

  • ►  2015 (1)
    • ►  March (1)
  • ►  2014 (3)
    • ►  May (3)
  • ►  2013 (1)
    • ►  November (1)
  • ►  2010 (6)
    • ►  May (1)
    • ►  April (5)
  • ►  2009 (7)
    • ►  December (1)
    • ►  June (1)
    • ►  February (5)
  • ▼  2008 (30)
    • ►  December (1)
    • ►  November (5)
    • ►  October (2)
    • ►  August (9)
    • ▼  June (13)
      • Explanation on Struts flow.
      • what is the use of reset() method in ActionForm?
      • The difference between MVC and MVC 2(MODEL 2) ?
      • What is AOP Aspect Oriented Programming ?
      • how to clone an object in Java? what is shallow co...
      • how to find the 2nd, 3rd ,4th ... nth highest sala...
      • what is the output of select * from table where 1=2?
      • select second highest salary from emp table
      • Explanation on Data Abstraction and Data Encapsula...
      • About Interface in Java
      • Explanation on Difference between TRUNCATE, DELETE...
      • how Class.forName() works exactly?
      • Problem facing with SQL Query, ORA-01425: escape c...