Member Avatar for 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

  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for 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

Member Avatar for debasisdas

Just use upper as suggested in the previous post.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.