19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.
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
Can you drop an index associated with a unique or primary key constraint?
How to create a new table by selecting rows from another table?
How to open and close an explicit cursor in oracle?
What is oracle thin client?
what are archived logs?
How to assign values to data fields in record variables?
what is insert all statement in sql
How to write a query with an inner join in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to end the current transaction in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to execute the package in oracle?
Why do you create or replace procedures rather that drop and recreate.
how can db_files > maxdatafiles since db_files is for instance and the later is for database