OraFAQ Forum: SQL & PL/SQL

Fri, 01 March 2002 20:52

Sam
Messages: 255
Registered: April 2000

Senior Member

I am trying to check if col x in table Y
has any data in lower case.
Is there a way to check this ?
Any help is appreciated.

Sun, 03 March 2002 13:22

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select *
  from y
 where x is not null
   and upper(x) <> x

Previous Topic:	Multi-Selection: Urgent
Next Topic:	how to run procedure within the package ?

Goto Forum:

]

Current Time: Thu Apr 25 06:39:20 CDT 2024