Oracle Urgent - how to get only the upper case data
 

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

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

Hi,

The following query gives all the data in upper case

select Currency_desc from tablename where upper(Currency_desc)=Currency_desc

thanks

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

Just use upper as suggested in the previous post.