Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   oracle doubt (http://www.go4expert.com/forums/oracle-doubt-t3476/)

kapoor007 19Mar2007 17:02

oracle doubt
 
i m havin a doubt in writing a query to select ename,eno of those employees whose name starts with a or s
what i feel is
select ename.eno from emp where ename (like 'a%' or like's%');
plz solve my doubt

shabbir 19Mar2007 17:33

Re: oracle doubt
 
. should be ,

Also

ename (like 'a%' or like's%'); should be ename like 'a%' or ename like's%';


All times are GMT +5.5. The time now is 13:53.