Oracle Urgent - how to get only the upper case data

[Anitha bala]

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

[Anitha bala]

Hi,

The following query gives all the data in upper case

select Currency_desc from tablename where upper(Currency_desc)=Currency_desc

thanks

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

[debasisdas]

Just use upper as suggested in the previous post.