473,289 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

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

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

Similar topics

1
by: Richard A. DeVenezia | last post by:
A page has a long running computation loop. While in the loop I want to update a status object so I know how things are going in the computation. This is what I have, but it doesn't seem to...
4
by: lost hope | last post by:
hey guys, on the main page of my site, i have a login area (user/pass text boxes). when the user submits the form, the page is reloaded with with a global php variable "loggedIn" set to true. i...
0
by: Eddy_w | last post by:
Hello, I try to ping from my mobile device with a wireless connection to my pc. I found the class clsping on the internet and it works perfect with application from pc to pc but when i use it...
20
by: newbie | last post by:
Hi all, http://www.aswin.be/nictransfer.JPG How can I get these numbers with VB.NET ? I thought somewhere in WMI but I can't find them. Thank you, Aswin
3
by: daveyand | last post by:
hey, I know in the new browsers you're not able to change the value of the status bar. Which is fair enough, i understand why and agree. Although, i cant seem to get the value of the status...
2
by: Mike Viuckery | last post by:
We have a table that is used as an audit trial -PK - DATETIME CHANGE WAS MADE - THE FILED THAT WAS CHANGED - ORIGINAL VALUE IN FIELD - wHAT THE VALUE WAS...
5
by: Laetitia | last post by:
Hi All Please can anyone advise whether it is possible to display messages in the status bar. I have a number of update queries which will be run and need to find a way to identify which...
9
by: tshad | last post by:
I have a Windows App that is doing some work and then writing a "Now Processing..." line to the status line of the window as well as the Textbox on the form. But the problem is that the work is...
0
by: tvnaidu | last post by:
I wrote a status page HTML code, here I have 8 port status, it prints first 7 and last status it won't print, from there onwards it won't print footer also, if I make 10 instead 8, then it prints...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.