Oracle PL/SQL/System Tables Views/ALL TRIGGERS

Read trigger name and Query all_Triggers table

   <source lang="sql">

  SET TERMOUT off
  SET FEEDBACK off
  COLUMN when_clause FORMAT a60 WORD_WRAPPED
  

SELECT "CREATE OR REPLACE TRIGGER " || description

  FROM ALL_TRIGGERS
  WHERE trigger_name = UPPER("&trigger_name")
  AND owner = UPPER("&trigger_owner");
  

SELECT "WHEN (" || when_clause || ")" when_clause

  FROM ALL_TRIGGERS
  WHERE trigger_name = UPPER("&trigger_name")
  AND owner = UPPER("&trigger_owner")
  AND when_clause IS NOT NULL;
  

SELECT trigger_body

  FROM ALL_TRIGGERS
  WHERE trigger_name = UPPER("&trigger_name")
  AND owner = UPPER("&trigger_owner");
</source>