Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Changing data in a column from lower to uppercase

user13390506Nov 2 2011 — edited Nov 3 2011
Hi guys, I was wondering if yous could help me out. I currently have a table in a database with quite alot of data on it and in one of the columns (varchar2 column, and for the sake of this question lets assume the table is called my_table and the column is called my_column) it contains data such as 'a3456', 'b8312' 'fg231' etc What I need to do is convert all of the lower case letters to upper case so that 'a3456' would now read 'A3456' and 'fg231' would now read 'FG231' and I was wondering what would be the best way to simply convert all these lower case letters to upper case.

Any help would be greatly appreciated.

Thanks for taking the time to read this.
This post has been answered by 6363 on Nov 2 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2011
Added on Nov 2 2011
4 comments
5,740 views