|
SQL>
SQL> SELECT 'ALTER TRIGGER ' || trigger_name || ' DISABLE;'
2 FROM user_triggers
3 where rownum < 50
4 ORDER BY table_name;
'ALTERTRIGGER'||TRIGGER_NAME||'DISABLE;'
-----------------------------------------------------
ALTER TRIGGER APPLICATION_USERS_IOI DISABLE;
ALTER TRIGGER HRC_ORG_SITE_TRIG DISABLE;
ALTER TRIGGER STUDENT_TRIG DISABLE;
ALTER TRIGGER CAPTURE_TRACE_FILES DISABLE;
ALTER TRIGGER WHAT_COLUMN DISABLE;
SQL>
SQL>
|