Comments on Oracle Database DBA: LIKE operator

ThankYou Sir....i missed to put first_name with &#...

2010-11-15T08:26:05.779-08:00

ThankYou Sir....i missed to put first_name with 'D'.

Try this: SQL> select first_name from employee...

2010-11-15T04:23:58.463-08:00

Try this:

SQL> select first_name from employees where first_name like 'A%' or first_name like 'D%';

Hello Sir, I used the like operator and i have one...

2010-11-14T22:39:42.465-08:00

Hello Sir,
I used the like operator and i have one question about it....as in example given above, if i want to find out the name and salary of employees whose first name starts with 'A' and 'D',then how to do that. I used'and' operator but its not working.....

Thanks,