Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6427 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
How to speed up webrick?
Which environment variables are absolutely critical in order to run the OUI?
How to create a new table in your schema?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different types of trigger and explain its various uses and functions?
How does the on-delete-cascade statement work?
How to sort the query output in oracle?
What is oracle datasource?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are dml statements in oracle?
What is oracle in java?
How do I call oracle stored procedures that take no parameters?
How to convert character types to numeric types?
What do you mean by merge in oracle and how can you merge two tables?
Explain implicit cursor.
