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
- 6335 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
What are the different types of modules in oracle forms?
How can we delete duplicate rows in a table?
How to assign a tablespace to a users in oracle?
What is a dead lock in oracle?
What is SQL Tuning Advisor in Oracle?
Explain compound trigger in oracle?
How many types of table in Oracle?
Explain the dml?
How to compare dates in oracle sql?
What is object data modeling?
Which environment variables are absolutely critical in order to run the OUI?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to define a data source name (dsn) in odbc manager?
How to update a table row with a record?
Differentiate between translate and replace?
