List of tables on which a trigger is used

[yoghee]

Hi friends,

I need to know is there is any way to know the
list of tables on which a trigger is used

[debasisdas]

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

select table_name from user_triggers Where trigger_name='TRIGNAME'

[yoghee]

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

select table_name from user_triggers Where trigger_name='TRIGNAME'

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"