Oracle Urgent - how to get only the upper case data

Reply

Join Date: Nov 2008
Posts: 2
Reputation: Anitha bala is an unknown quantity at this point 
Solved Threads: 0
Anitha bala Anitha bala is offline Offline
Newbie Poster

Oracle Urgent - how to get only the upper case data

 
0
  #1
Nov 30th, 2008
hi,

I need to know how to get only the upper case currency from a table using oracle.


e.g:- data for currency will be as follows

USD
AUD
EUR
SGD
AUd
uSD
EuR

I need to get only the upper case currency among all the other currency such as
USD
AUD
EUR
SGD

what is the logic need to be used for it?

Thanks in advance
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 2
Reputation: Anitha bala is an unknown quantity at this point 
Solved Threads: 0
Anitha bala Anitha bala is offline Offline
Newbie Poster

Re: Oracle Urgent - how to get only the upper case data

 
0
  #2
Dec 1st, 2008
Hi,

The following query gives all the data in upper case

select Currency_desc from tablename where upper(Currency_desc)=Currency_desc

thanks

Originally Posted by Anitha bala View Post
hi,

I need to know how to get only the upper case currency from a table using oracle.


e.g:- data for currency will be as follows

USD
AUD
EUR
SGD
AUd
uSD
EuR

I need to get only the upper case currency among all the other currency such as
USD
AUD
EUR
SGD

what is the logic need to be used for it?

Thanks in advance
Reply With Quote Quick reply to this message  
Join Date: Feb 2007
Posts: 2,091
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 125
debasisdas's Avatar
debasisdas debasisdas is online now Online
Postaholic

Re: Oracle Urgent - how to get only the upper case data

 
0
  #3
Dec 1st, 2008
Just use upper as suggested in the previous post.
Share your Knowledge.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Oracle Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC