Create alter trigger command by query user_triggers table : user_triggers « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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>








30.106.user_triggers
30.106.1.Getting Information on Triggers
30.106.2.find out all triggers from user_triggers table
30.106.3.Create alter trigger command by query user_triggers table