Oracle: DBA_TRIGGERS

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;

select
   *
from
   dba_triggers
where
   triggering_event = 'LOGON ' -- Note the trailing space.
;

select * from dba_triggers where base_object_type = 'VIEW';
select * from dba_triggers where base_object_type = 'TABLE';  
select * from dba_triggers where base_object_type = 'SCHEMA';  
select * from dba_triggers where base_object_type = 'DATABASE        ';