Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6339 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suresh babu
select client_name from client where client_name like 'j%'
or client_name like '%M%' or client_name like '___E%';
| Is This Answer Correct ? | 1 Yes | 1 No |
Why does oracle 9i treat an empty string as null?
difference between oracle8i and oracle9i
can we insert any row to dual table if i got the permission from DBA
How can windows applications connect to oracle servers?
How much memory your 10g xe server is using?
Which is faster join or subquery in oracle?
What are the different windows events activated at runtime ?
Define the terms primary key foreign key and also the difference between primary and the unique key
How to do paging with oracle?
what is index?
What are dml statements in oracle?
What is a Database instance ? Explain?
Oracle General 
