plsql 批量修改表名和字段名为小写

1.修改表名

--修改表名小写
SELECT 'alter table "'||table_name||'" rename to "'||alower||'";' FROM (
 SELECT table_name, "lower"(table_name) alower FROM  information_schema.tables t  
 where table_schema='public' ) b WHERE table_name <> alower;

2.修改字段名

SELECT 'alter table "'||table_name||'" rename "'||column_name||'" to "'||alower||'";' FROM (
 SELECT table_name, "column_name", "lower"(column_name) alower FROM  information_schema.columns t
 where table_schema='public' ) b WHERE column_name <> alower and table_name='dxkjyjb';

执行完会出现对应语句，如下：
 alter table "dxkjyjb" rename "YJ_YLB_RKSJ" to "yj_ylb_rksj";
alter table "dxkjyjb" rename "YJ_YLB_SJ" to "yj_ylb_sj";

直接运行即可