-- Query to find triggers on a table (privileged user can 
-- query all_triggers or dba_triggers.

SELECT
 trigger_name ,trigger_type ,triggering_event 
FROM  user_triggers
WHERE  table_name = UPPER('&table_name')
;

-- Trigger text/code

SELECT
 trigger_body
FROM  user_triggers
WHERE  trigger_name = UPPER('&trigger_name')
;

ALTER TABLE table_name ENABLE ALL TRIGGERS;

ALTER TRIGGER trigger_name  DISABLE;

ALTER TRIGGER trigger_name  COMPILE;