The triggers' source code can be queried from dba_procedures
select
trg.owner,
trg.trigger_name,
--
trg.action_type, -- PL/SQL or CALL
trg.trigger_type, -- [BEFORE|AFTER] STATEMENT, [BEFORE|AFTER] EACH ROW, INSTEAD, COMPOUND
--
trg.before_row , trg.after_row,
trg.before_statement, trg.after_statement,
--
trg.when_clause -- An expression that must evaluate to true in order for the trigger to fire
--
trg.apply_server_only, -- YES: Trigger will only fire for a Replication Apply or SQL Apply process.
trg.base_object_type, -- TABLE, VIEW, SCHEMA or DATABASE
trg.column_name,
trg.crossedition,
trg.description,
trg.fire_once,
trg.instead_of_row,
trg.referencing_names,
trg.status,
trg.table_name,
trg.table_owner,
trg.trigger_body,
trg.triggering_event
from
SYS.dba_triggers trg;
Finding LOGON triggers
The value of triggering_event has a trailing space for logon triggers.
select
*
from
dba_triggers
where
triggering_event = 'LOGON ' -- Note the trailing space.
;