469,325 Members | 1,596 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

the status field value

4
<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"
May 3 '07 #1
4 1591
Hello

SELECT All_TRIGGERS.*, DECODE(STATUS,'ENABLED','VALID','INVALID') STATUSS
FROM All_TRIGGERS WHERE TRIGGER_NAME ='TRIGGER'

Try, this may help you

Reshmi

<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"
May 3 '07 #2
debasisdas
8,127 Expert 4TB
Dear
Reshmi Jacob

in oracle 'ENABLED','DISABLE' AND ''VALID','INVALID' are 2 diffeent things as per a TRIGGER.

ENABLE/DISABLE-- specifies either the trigger is enabled or not to fire.

VALID/INVALID---specifies what is the status on the object.
Usually triggers become invalid if the base object is invalid .
May 3 '07 #3
yoghee
4
Dear
Reshmi Jacob

in oracle 'ENABLED','DISABLE' AND ''VALID','INVALID' are 2 diffeent things as per a TRIGGER.

ENABLE/DISABLE-- specifies either the trigger is enabled or not to fire.

VALID/INVALID---specifies what is the status on the object.
Usually triggers become invalid if the base object is invalid .

hi das
i need to get the colum which specifies the status of the object as u said
May 3 '07 #4
debasisdas
8,127 Expert 4TB
Expand|Select|Wrap|Line Numbers
  1. SELECT STATUS FROM USER_OBJECTS WHERE OBJECT_NAME ='TRIGGERNAME';
  2.  
the above query returns the status ob the object i.e.--VALID / INVALID
May 3 '07 #5

Post your reply

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

Similar topics

1 post views Thread by Richard A. DeVenezia | last post: by
4 posts views Thread by lost hope | last post: by
reply views Thread by Eddy_w | last post: by
3 posts views Thread by daveyand | last post: by
5 posts views Thread by Laetitia | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | 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.