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