Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Create alter trigger command by query user_triggers table

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>