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
- 6465 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
Are truncate and delete commands same? If so why?
What is the fastest query method to fetch data from the table?
What is the difference between PFILE and SPFILE in Oracle?
Explain about achiever in sql?
Explain what are the advantages of views?
How to sort output in descending order in oracle?
Explain what are clusters?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is data block in Oracle?
What is a directory object?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to use group functions in the select clause using oracle?
Which is faster join or subquery in oracle?
What is the parameter mode that can be passed to a procedure?
