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
- 6476 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 |
What are the execution control statements in oracle?
What are the different types of synonyms?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
Explain self joins in oracle?
How to estimate disk space needed for an export job?
How to export your own schema?
How to recover a dropped index?
How do we create privileges in oracle?
how to delete all duplicate records from a table using subquery?
What is difference between SUBSTR and INSTR?
what is difference between cartesian join & cross join even they give same result?
Oracle General 
