CODEWITHSUNDEEP
sqloracle-database
user5999241
user5999241

Reputation:

How to fetch Only Uppercase values in Oracle

I have two values For example:

I have a question as below

   A
----------
1) [email protected]

2) [email protected]

I want only the Upper case value as output like below

 OUTPUT : A
----------
[email protected]

Upvotes: 1

Views: 591

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269447

By default, Oracle is case sensitive. So you can do this comparison:

select *
from t
where a = upper(a);

Upvotes: 6

Related Questions