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
- 6473 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Difference between open_form and call_form in oracle.
How to create a new table by selecting rows from another table?
What is the data pump import utility?
How to Remove the 3rd highest salary person record from table?
What is oracle rownum?
What are the uses of a database trigger?
Explain the function of optimizer in oracle?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How do we display rows from the table without duplicates?
What is pragma autonomous transaction in oracle?
How to define a cusotmer as a supplier in ORACLE R12
What privilege is needed for a user to create tables in oracle?
Oracle General 
