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
- 6384 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 |
Explain overloading. Can functions be overloaded?
what is kernel?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
How to select an oracle system id (sid)?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to connect to a local oracle 10g xe server?
What is the difference between translate and replace?
What is oracle database client?
What is an oracle and why it is used?
where do i find oracle interview questions.
Oracle General 
