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

Home -> Community -> Usenet -> c.d.o.misc -> Trigger Code

Trigger Code

From: Redd <javatek?_at_usa.com>
Date: Sat, 20 Mar 2004 19:28:48 -0600
Message-ID: <Zd67c.94318$JN2.75110@bignews4.bellsouth.net>


I am trying to implement a trigger to update a field and these are the columns.

Quantity           Integer
OldQuantity     Integer
OnOrder           Char


Does anyone know how to write the trigger that on update if Quantity is equal to or less than OldQuantity write the Character "T" to the OnOrder field. Received on Sat Mar 20 2004 - 19:28:48 CST

Original text of this message

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