19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.
- 2 Answers
- 6665 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / saiprasannach89
select cname from client where lower(ename) like 'j%' or lower(cname) like '%m%' or select cname from emp where lower(cname) like 's%' or lower(cname) like '___e%';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a left outer join with the where clause in oracle?
How to start an oracle instance?
How to put more than 1000 values into an oracle in clause?
How to select all columns of all rows from a table in oracle?
How to use values from other tables in update statements using oracle?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
