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 is a table index?
What is a snapshot in oracle database?
Where do you use decode and case statements?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What are the differences between number and binary_float in oracle?
what is the difference between restoring and recovering?
Can you create a synonym without having a table?
How to count groups returned with the group by clause in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to create a table index in oracle?
What is oracle database 10g express edition?
What is a table index in oracle?
How to save query output to a local file?
What language does oracle use?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?