Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   On Escape characters..ORACLE (http://www.go4expert.com/forums/on-escape-charactersoracle-t16559/)

srijith.ramachandran 17Mar2009 01:47

On Escape characters..ORACLE
 
Hi All,

i have a query...

why does the below sql query ie (a) returns no row, while the statement (b) displays rows

(a) select * from sri where ename='%AME%';

----->no rows selected

(b) select * from sri where ename='JAMES';

--->
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ---------- --------- ---------- ---------- ----------
7900 JAMES CLERK 7698 03-DEC-81 950 30

xpi0t0s 17Mar2009 04:43

Re: On Escape characters..ORACLE
 
Because you need to use LIKE, i.e. ename LIKE '%AME%'.

shabbir 17Mar2009 06:00

Re: On Escape characters..ORACLE
 
Moved to Oracle Forum


All times are GMT +5.5. The time now is 20:35.