Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to do the UPDATE Trigger??
Hello everybody,
I have a question about UPDATE:
I have 2 table : DAILY and MONTHS
DAILY: Example of table DAILY: ------------------------------- ------------------------------------- ON_DATE CHAR(8) 19990301 A TYPE CHAR(1) 19990302 A 19990303 B ::::::::::::::: 19990331 D MONTHS: Example of table MONTHS: ------------------------------ ---------------------------------------- ON_YYMM CHAR(6) 199903 A A B ::::::::::::::::: D TYPE_01 CHAR(1) TYPE_02 CHAR(1) TYPE_03 CHAR(1) :::::::::::::::::: TYPE_31 CHAR(1) If I update DAILY => update MONTHS : 19990301 'C' SET TYPE_01 = 'C' WHERE ON_YYMM=SUBSTR(:new.on_date,1,6) 19990302 'B' SET TYPE_02 = 'B' WHERE ON_YYMM=SUBSTR(:new.on_date,1,6) 19990303 'D' SET TYPE_03 = 'D' WHERE ON_YYMM=SUBSTR(:new.on_date,1,6)
How to CREATE the Trigger?
Really Need Help !!
Thank you in advance.
Violin.
violin.hsiao_at_mail.pouchen.com.tw
Received on Tue Mar 30 1999 - 02:11:52 CST