On Escape characters..ORACLE

Newbie Member
17Mar2009,01:47   #1
srijith.ramachandran's Avatar
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
Mentor
17Mar2009,04:43   #2
xpi0t0s's Avatar
Because you need to use LIKE, i.e. ename LIKE '%AME%'.
Go4Expert Founder
17Mar2009,06:00   #3
shabbir's Avatar
Moved to Oracle Forum