hi das
i need to get the colum which specifies the status of the object as u said...
yoghee
Last Activity: May 3 '07, 12:18 PM
Joined: May 3 '07
Location:
-
the status field value
<code>SELECT *
FROM All_TRIGGERS WHERE TRIGGER_NAME ='TRIGGER' </code>
By using this query , the status field value is "Enabled" or "Disabled" , but i need it in a format in which the status should be "valid" or "invalid" -
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"...Leave a comment:
-
List of tables on which a trigger is used
Hi friends,
I need to know is there is any way to know the
list of tables on which a trigger is used
No activity results to display
Leave a comment: