Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Retrieve the detail from emp
This is a discussion on Retrieve the detail from emp within the Oracle forums, part of the Databases category; Question asked by visitor siddharth Retrieve the detail from emp table with help of ename where ename may be in any case like (SCOTT,ScoTT, scott,scOtt)...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
04-04-2007
|
|||
|
|||
|
Retrieve the detail from emp
Question asked by visitor siddharth
Retrieve the detail from emp table with help of ename where ename may be in any case like (SCOTT,ScoTT, scott,scOtt) 
|
| Sponsored Links |
|
05-10-2007
|
|||
|
|||
|
Re: Retrieve the detail from emp
Hi,
either of following:- select * from emp where lower(ename) like '%scott%'; or select * from emp where upper(ename) like '%SCOTT%'; Reeta
|
|
05-24-2007
|
|||
|
|||
|
Re: Retrieve the detail from emp
Hi,
Using Case Manipulation functions (Upper, Lower, Initcap) will be more appropriate for this validation.
__________________
*** Innila ***
|
|
07-12-2007
|
|||
|
|||
|
Re: Retrieve the detail from emp
if u are sure the loist contains 'scott' in any case then go for
select * from emp where lower(ename)='scott' else try to use like search
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Retrieve data from emp table | Sampurna | SQL | 4 | 08-13-2008 08:07 AM |
| Can you help me prepare a detail resume? | Geek_Guest | Resume Help | 1 | 06-28-2007 04:36 PM |
| Please give me detail about CDAC exam | Geek_Guest | Career Advice | 0 | 04-03-2007 11:04 AM |
| Help me retrieve my password | joel | MY SQL | 1 | 12-19-2006 02:53 AM |
| Retrieve a pdf document from database | Lokesh M | Database General | 5 | 12-18-2006 08:44 AM |
All times are GMT -4. The time now is 09:21 PM.
