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
- 6429 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 |
Give the advantages and disadvantages of clusters.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is the minimum client footprint required to connect c# to an oracle database?
What exactly do quotation marks around the table name do?
What is the difference between a user and a schema in oracle?
How to use windows user to connect to the server?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What is not equal to in oracle?
who is the father of oracle and send chodd rules
Explain about the analyze command in oracle?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Oracle General 
