可以使用mysql,如下所示:
https://www.electrictoolbox.com/rename-multiple-tables-mysql/
预言机可以采取类似的操作吗?
像这样:
Alter table tbl1 rename to new1, tbl2 to new2;
我能想到的另一种方法是您可以使用单个select
从ALL_TABLES
生成多个ALTER
命令。
SELECT 'Alter table '
||table_name
||' rename to '
||table_name
||'_NEW'
||rn||';' Alter_command
FROM
(SELECT ROWNUM rn ,
a.*
FROM ALL_TABLES a
WHERE TABLE_NAME IN ('<LIST_OF_TABLES>')
) ORDER BY TABLE_NAME;
输出:
Alter table ABCD_TMP rename to ABCD_TMP_NEW1509;
Alter table ABCD_TMP3 rename to ABCD_TMP3_NEW1510;
Alter table ACCESS$ rename to ACCESS$_NEW46;
Alter table ACCOUNT rename to ACCOUNT_NEW1549;
Alter..
.....