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

how to clone 9i Database on to 10g Database.

2319

Why is oracle used?

922

State and explain the different types of data models?

925

What privilege is needed for a user to create indexes in oracle?

1011

How to omit columns with default values in insert statement in oracle?

1036

Is java required for oracle client?

971

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

1038

What are the attributes that are found in a cursor?

1045

What is the difference between PFILE and SPFILE in Oracle?

1037

Give the various exception types.

975

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2094

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

Does oracle database need java?

985

What is null value in oracle?

1075

What is a user account in oracle?

1103