19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.
- 2 Answers
- 5423 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / saiprasannach89
select cname from client where lower(ename) like 'j%' or lower(cname) like '%m%' or select cname from emp where lower(cname) like 's%' or lower(cname) like '___e%';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are clusters?
When do we use group by clause in a sql query?
What is the data type of dual table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How do we display rows from the table without duplicates?
How to handle a single quote in oracle sql?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How can we find out the current date and time in oracle?
What is a system tablespace and when it is created?
Why should I use oracle database?
Can we write insert statement in function in oracle?
How to select all columns of all rows from a table in oracle?
What is an oracle user account?
How to update values in a table in oracle?
How will you write a query to get a 5th rank student from a table student_report?
