Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to do the UPDATE Trigger??

How to do the UPDATE Trigger??

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 30 Mar 1999 08:11:52 GMT
Message-ID: <370079b5.25725601@news.twsc.pouchen.com.tw>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US