Oracle生成关闭外键的SQL语句

select 'alter table ' || t.table_name || ' disable constraint ' || t.constraint_name || ';'
from DBA_CONSTRAINTS t WHERE t.CONSTRAINT_TYPE = 'R' and OWNER = 'SWT_ZCPT'
order by t.TABLE_NAME;
原文地址:https://www.cnblogs.com/boazy/p/7561178.html