this is my before row trigger template...

CREATE TRIGGER table_name_tr
BEFORE
INSERT OR DELETE OR UPDATE
ON table_name
FOR EACH ROW
begin
if inserting then
null;
elsif updating then
null;
else -- if deleting
null;
end if;
end;
/

hope this is of use

nickc
-----Original Message-----
From: Patel Daxa
[mailto:oracledba-ezmlmshield-x56168973.[Email address protected]
Sent: 15 November 2004 15:08
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