Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forumdisplay.php?f=39)
-   -   oracle doubt (http://www.go4expert.com/showthread.php?t=3476)

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 10:59.