select client_name from client where client

19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.

Question Posted / suresh babu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Design database draw er diagram for a certain scenario ?

4656

How to put more than 1000 values into an oracle in clause?

1115

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to start an oracle instance?

1103

How to use values from other tables in update statements using oracle?

1158

What is oracle latest version?

1174

How to write a left outer join with the where clause in oracle?

1156

How to select all columns of all rows from a table in oracle?

1132