Hi
use the following query and input table name.
select OWNER,TRIGGER_NAME,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OWNER
from all_triggers
where Table_name = upper('&table_name')
Regards
Binu
On 10/11/08, raja <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Please answer to the following question :
>
> Which table will give the list of triggers in the schema ?
> a. Need to know whether accessing/quering that table requires dba
> rights or not?
> b. is the table name, to get the list of triggers, is same for both
> oracle 9i and 10g ?
>
> With Regards,
> Raja.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
