469,327 Members | 1,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

List of tables on which a trigger is used

4
Hi friends,

I need to know is there is any way to know the
list of tables on which a trigger is used
May 3 '07 #1
2 2158
debasisdas
8,127 Expert 4TB
First of a trigger can be made to fire on a single table.
U can write a trigger only on a single base table .

EXCEPTION---INSTEAD OF TRIGGERS


try

Expand|Select|Wrap|Line Numbers
  1.  
  2. select table_name from user_triggers Where trigger_name='TRIGNAME'
  3.  
May 3 '07 #2
yoghee
4
First of a trigger can be made to fire on a single table.
U can write a trigger only on a single base table .

EXCEPTION---INSTEAD OF TRIGGERS


try

Expand|Select|Wrap|Line Numbers
  1.  
  2. select table_name from user_triggers Where trigger_name='TRIGNAME'
  3.  
By using this query , the status is "Enabled" or "Disabled" , but i need it in a format in which the status should be "valid" or "invalid"
May 3 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by david_0 | last post: by
81 posts views Thread by sinister | last post: by
5 posts views Thread by Raphael Bauduin | last post: by
13 posts views Thread by Rahul B | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.