No of triggers in Oracle 8i

[Guest_imported]

Hello,

Please anyone tell me how many triggers
are there overall in oracle 8i.Could anyone give
me the list of triggers.In no book,they have
mentioned about no of triggers.Please help in this
regard.

Thanks in advance

Bye
Sugi Motto

 

[stefanhei]

Hi.
Try (when logged in as DBA)
SELECT owner,count(*)
FROM dba_triggers
GROUP BY owner

to find out number

and
SELECT onwer,trigger_name FROM dba_triggers
for the names of the triggers.

Stefan