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. |
character
This is a discussion on character within the Oracle forums, part of the Databases category; How can we select then employee name in any case with out using Lower and Upper Functions?...
|
|||||||
| 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 |
08-14-2009
|
|||
|
|||
|
character
How can we select then employee name in any case with out using Lower and Upper Functions?
|
| Sponsored Links |
|
08-14-2009
|
|||
|
|||
|
Re: character
If you want the data in any case why you need to use UPPER and LOWER functions.
Select the data as is in the tables. No need to go for any conversion.
|
|
08-28-2009
|
|||
|
|||
|
Re: character
The records being stored insdie the Oracle database, are case sensitive (i,e. data inside tables). Three types of conversions are there to change the case of any character data 1. LOWER (oracle) 2. UPPER (ORACLE) 3. INITCAP (Oracle). If you are not using any of these functions while selecting and/or inserting the records then it will be fetched as it was entered during insertion into table.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Output the duplicated character | teetoo | VB.NET | 1 | 12-06-2007 01:29 AM |
| character array | pbchaudhari | C and C++ | 2 | 10-27-2007 04:41 AM |
| Float or character in place of int | Geek_Guest | C and C++ | 5 | 10-27-2007 04:35 AM |
| Converting single character to string | Geek_Guest | Java | 2 | 08-24-2007 09:42 AM |
| HTML/PDF - Newline Character | psuresh1982 | AJAX & XML | 0 | 07-31-2007 05:37 AM |
All times are GMT -4. The time now is 06:02 AM.
