do you want syntax for writing a trigger ?....see any basic Oracle pl/sql book.....



-----Original Message-----
From: Patel Daxa
[mailto:oracledba-ezmlmshield-x56168973.[Email address protected]
Sent: Monday, November 15, 2004 6:08 PM
To: LazyDBA Discussion
Subject: RE: TRIGGER



Hi
Here is my table and I want to write Trigger on insert or
update..
Can any body help me?
Thanks in advance
Patel

CREATE TABLE QICORE.QIC_workorder

(
request_id number,
OBJECT_NAME VARCHAR2(100),
object_type VARCHAR2(100),
request_DATE DATE,
REQUEST_BY VARCHAR2(100),
ACTION VARCHAR2(100),
OLD_VALUE VARCHAR2(100),
NEW_VALUE VARCHAR2(100),
TEST_DB CHAR(6),
PROD_DB CHAR(6),
COMPLETION_DATE DATE,
COMPLETION_BY VARCHAR2(100),
QA_DATE DATE,
QA_BY VARCHAR2(100),
SYNCHRO_DATE DATE,
SYNCHRO_BY VARCHAR2(100),
APP_VERSION VARCHAR2(100),
COMMENTS VARCHAR2(400),



)



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page