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

Describe an oracle table?

567

What is blob data type in oracle?

555

Explain the features of oracle?

592

How to set up autotrace for a user account?

592

How to sort the query output in oracle?

608

What is snapshot is too old? Give and example for better understand.

1097

How to write date and time literals in oracle?

555

What is oracle and what are its different editions?

573

What are the set operators union, union all, minus & intersect meant to do?

560

How to convert characters to numbers in oracle?

593

What are the parameters that we can pass through a stored procedure?

551

Explain the blob datatype?

612

List out the types of joins.

591

Explain how are indexes update?

619

How to create a new table in your schema?

605