the status field value

[yoghee]

<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"

[Reshmi Jacob]

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"

[debasisdas]

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 .

[yoghee]

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

[debasisdas]

SELECT STATUS FROM USER_OBJECTS WHERE OBJECT_NAME ='TRIGGERNAME';
 

the above query returns the status ob the object i.e.--VALID / INVALID