批量修改表名和列名

一、表名处理sql：

select 'alter table "' || table_name || '" rename to ' || upper(table_name) || ';'

  from user_tables

 where table_name <> upper(table_name);

二、列名处理sql：

select 'alter table "' || table_name || '" rename column  "' || column_name ||

       '"   to   ' || upper(column_name) || ';'

  from user_col_comments

 where column_name <> upper(column_name)

   and table_name in (select table_name from user_tables)