Can anyone tell me how to convert whole table into UPPER CASE? i had this requirement, i know to do this every column wise in each table. I have this requirement for many tables.
If there are many tables to do this for, it may be worth creating an SQL query that will generate the CTAS statements with UPPER(colname) for Character columns from the appropriate system catalog tables.
