1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

oracle doubt

Discussion in 'Oracle' started by kapoor007, Mar 19, 2007.

  1. kapoor007

    kapoor007 New Member

    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
     
  2. shabbir

    shabbir Administrator Staff Member

    . should be ,

    Also

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

Share This Page