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
- 6573 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why packages are used in oracle?
What privilege is needed for a user to create tables in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How translate command is different from replace?
Can a parameter be passed to a cursor?
What is the difference between a user and a schema in oracle?
What is a table in oracle?
How to create id with auto_increment on oracle?
How to get last row id?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Can a formula column referred to columns in higher group ?
What is a table index?
Explain about your project and its relation to the current job position you are applying to?
What is an oracle function?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
