SPOOL C:/A.TXT
select 'rename "'||table_name||'" to '||upper(table_name)||';' from user_tables;
SPOOL OFF
sql>@c:/A.txt
Oracle表名改為大寫
最新推荐文章于 2022-04-24 20:56:08 发布
SPOOL C:/A.TXT
select 'rename "'||table_name||'" to '||upper(table_name)||';' from user_tables;
SPOOL OFF
sql>@c:/A.txt