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
- 6577 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 is not equal to in oracle?
Are truncate and delete commands same? If so why?
sql query to get zero records from a table
How to list all indexes in your schema?
How to calculate date and time differences in oracle?
master table and child table performances and comparisons in Oracle ?
how to get last monday of a month?
How to use an explicit cursor without open statements?
What is an oracle data file?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
What types of joins are used in writing subqueries?
What is oracle database client?
Oracle General 
