Home » SQL & PL/SQL » SQL & PL/SQL » Converting a columns to uppercase..
Converting a columns to uppercase.. [message #35873] Sun, 21 October 2001 20:00 Go to next message
Sreenivas Gattu.
Messages: 2
Registered: October 2001
Junior Member
Hello,
I have a mix of lowercase and uppercase characters for a column in a oracle table.
I want to convert that column to all uppercase letters in an sql script and restore it in a database.
Can you plz tell me..How to do this..

Thanks.

----------------------------------------------------------------------
Re: Converting a columns to uppercase.. [message #35875 is a reply to message #35873] Sun, 21 October 2001 22:07 Go to previous message
Mathias
Messages: 3
Registered: October 2001
Junior Member
Hello,

that's an easy update statement:

update "table" set column = upper(column);

You also can use lower(column) to convert everything to lower letters.

Hope it helps,
Mathias

----------------------------------------------------------------------
Previous Topic: Inserting text with apostrophes
Next Topic: Re: Using Connect inside a PL/SQL procedure.
Goto Forum:
  


Current Time: Sun Mar 29 11:24:31 CDT 2020