结果集是生成sql语句,需要再次执行
约束删除
select ‘alter table ‘||table_name||’ drop constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 drop constraint CONS134218765;
约束失效
select ‘alter table ‘||table_name||’ disable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 disable constraint CONS134218765;
约束生效
select ‘alter table ‘||table_name||’ enable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 enable constraint CONS134218765;
结果集是生成sql语句,需要再次执行
约束删除
select ‘alter table ‘||table_name||’ drop constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 drop constraint CONS134218765;
约束失效
select ‘alter table ‘||table_name||’ disable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 disable constraint CONS134218765;
约束生效
select ‘alter table ‘||table_name||’ enable constraint ‘||constraint_name||’;’ from user_constraints where constraint_type=‘R’
结果集:alter table TABLE_1 enable constraint CONS134218765;