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
- 5454 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to load a large xml file?
Explain the use of show option in imp command.
What is the difference between substr and instr?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how to clone 9i Database on to 10g Database.
Explain the types of exception?
What is sequence?
What is the order of defining local variables and sub procedures/functions?
Explain integrity constraint?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the difference between view and materialized view in Oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What privilege is needed for a user to create indexes in oracle?
Explain about integrity constraint?
How different is ms access and oracle?
