19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.
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 |
Post New Answer View All Answers
What are the attributes of the cursor?
how may join possible between (requisition with purchase order)
How to use null as conditions in oracle?
How to add a new column to an existing table in oracle?
What is a user account in oracle?
What is difference between cartesian join and cross join?
How to set a transaction to be read only in oracle?
What is recycle bin in Oracle?
How to convert times to characters in oracle?
Explain constraining triggers.
Give the different types of rollback segments.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Is there a combination of "like" and "in" in sql?
How do I find the database name in oracle?
How to do clean up if create database failed?