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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Trigger Code

Re: Trigger Code

From: Redd <javatek?_at_usa.com>
Date: Sat, 20 Mar 2004 19:39:25 -0600
Message-ID: <Sj67c.58974$xL3.40979@bignews1.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:39:25 CST

Original text of this message

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