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
- 6663 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 a materialised view?
Shall I get Pro*C Compiler in Oracle-10g release ?
What is a sub query and what are the different types of subqueries?
20. Using a set operator, display the client number of all clients who have never placed an order.
what are archived logs?
What is flashback in Oracle?
Explain cascading triggers.
Why we choose emp number as primarykey?
what is null value?
difference between procedures and function?
Why do you create or replace procedures rather that drop and recreate.
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Oracle General 
