Converting a columns to uppercase.. [message #35873] |
Sun, 21 October 2001 20:00 |
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 |
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
----------------------------------------------------------------------
|
|
|