Oracle Urgent - how to get only the upper case data

Expand 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

Anitha bala

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Dec 1st, 2008

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

Click to Expand / Collapse Quote originally posted by 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

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2008

Permalink

Dec 1st, 2008

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

Just use upper as suggested in the previous post.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: oracle how to identify the last entry of the each item

Next Thread in Oracle Forum Timeline: Oracle SQL Plus Joining

DaniWeb Message

Cancel Changes

User Name
Password