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
- 6435 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to assign values to data fields in record variables?
How to use like conditions in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are the four Oracle system processes that must always be up and running for the database to be useable?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to get maxsal , minsal, ename department wise in single query
What is the minimum client footprint required to connect c# to an oracle database?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
What is Library Cache in Oracle?
How to convert characters to dates in oracle?
How to convert character types to numeric types?
Oracle General 
