|
SQL>
SQL> SELECT 'ALTER TABLE ' || table_name || ' DISABLE ALL TRIGGERS;'
2 FROM user_tables a
3 WHERE EXISTS
4 (SELECT 'X'
5 FROM user_triggers
6 WHERE table_name = a.table_name)
7 and rownum < 2
8 ORDER BY table_name;
'ALTERTABLE'||TABLE_NAME||'DISABLEALLTRIGGERS;'
----------------------------------------------------------------
ALTER TABLE STUDENT DISABLE ALL TRIGGERS;
SQL>
SQL>
|