select cname from client where lower(ename) like 'j%' or lower(cn

19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.

Question Posted / saiprasannach89

2 Answers
6340 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

Please Help Members By Posting Answers For Below Questions

How to update values in a table in oracle?

962

What is PL/SQL ?

1907

What are the benefits of ordbms?

1024

Give the various rollback segment states.

1000

What are the differences between interval year to month and interval day to second?

965

What is oracle in java?

913

How to add a new column to an existing table with a default value?

967

How translate command is different from replace?

1009

What is a user account in oracle?

1069

What is Library Cache in Oracle?

1077

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2046

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4295

please explain.. DB architecture ...

1968

How to create a new table in oracle?

1067

Can we protect our pl/sql source code?

994