| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Trigger question
Hallo,
I have the table system_change
and I I have the insert statement here below be run when there is an update or insert of any of the fields
ORGANIZATION_NUMBER
LEGAL_NAME
COMPANY_FORM_ID
ORDER_STOP
in table COMPANY
The script bo be run is this one:
insert into system_change
values(system_change_id.nextval, 1, null,null, null, null, null, 1, SYSDATE, 1, SYSDATE,1 )
How can I write the code in the easiest way?
All help is appreciated!
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: roland.skoldblom_at_ica.se
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 22 2004 - 08:24:27 CST
 |
 |