19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.
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 named program unit?
where do i find oracle interview questions.
What is background process in Oracle?
How to invoke the original export import utilities?
How to remove a row in a database table?
How to create a new oracle data file?
i want department wise maxmum salary and empolyee name
What is a Data File ?
Can a field be used in a report without it appearing in any data group ?
Can we create more than one index on particular column?
What is the difference between a hot backup and a cold backup in oracle?
query to find the maximum no persons with same age(age colomn) from emp table