On Oct 11, 1:19 am, "Binu K S" <[EMAIL PROTECTED]> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Let's answer the questions as posted:
Which table will give the list of triggers in the schema ?
USER_TRIGGERS
a. Need to know whether accessing/quering that table requires
dba rights or not?
No, it's a view accessible to every connected user of the database.
b. is the table name, to get the list of triggers, is same for
both oracle 9i and 10g ?
Yes, it is.
To return the basic in formation on all triggers in the schema the
following query can be used:
select trigger_name, trigger_type, triggering_event
from user_triggers;
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
