SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert mixed case value in colum into upper case values

682000Jul 18 2009 — edited Jul 19 2009

Hi All,
I have got a table call emp and has the following colums:

id number 10
suename_name varchar2(20)
given_name varchar2(20)
position varchar2(30)
date_hired date
.
.

Now the values in colums are mixed case and I need to change them to upper case. I think I need to use upper function to do it.

Could anyone help me by providing me sql/pl sql script to through each colum in emp table and change them to the upper case.

Many Thanks

Michael

This post has been answered by Frank Kulash on Jul 19 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2009

Added on Jul 18 2009

11 comments

1,902 views