Why don't you search on the web?

Your question doesn't make sense...


Your table with this code will not be created...


What do you want to do with your trigger?


Please, be more specific!!!!!






-----Original Message-----
From: Patel Daxa
[mailto:oracledba-ezmlmshield-x56168973.[Email Address Removed] zyDBA.com]
Sent: segunda-feira, 15 de Novembro de 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