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 |
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
how will I find the first 5 highest salaried employees in each dept in oracle.
Difference between open_form and call_form in oracle.
What is oracle thin client?
How to get a list of all background sessions in the database?
What is user managed backup in Oracle?
Whether any commands are used for months calculation? If so, what are they?
What is connection pooling in oracle?
where do i find oracle interview questions.
What is a oracle database?
How to define an anonymous procedure with variables?
How do I uninstall oracle client from windows?