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 -> Re: Table Trigger to set last_update_date field.

Re: Table Trigger to set last_update_date field.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 9 Mar 2000 17:40:03 +0100
Message-ID: <952629063.18509.1.pluto.d4ee154e@news.demon.nl>


pre-insert or update
:new.last_update_date = sysdate;

and that is all.

Hth,

Sybrand Bakker, Oracle DBA

Richard Billingsley <rbillingsley_at_deadend.com> wrote in message news:ruPx4.9317$yV1.2222176_at_tw11.nn.bcandid.com...
> I have been asked to create a table trigger that will update the
> last_update_date field for each record that is inserted or updated.
>
> Not being a trigger expert I have created the following code:
>
> create trigger set_update_date
> AFTER INSERT or UPDATE on STORM_PERSONNEL for each row
> begin
>
> update storm_personnel
> set last_update_date = sysdate
> where storm_pers_id = :new.storm_pers_id;
>
> end;
> /
>
> Personally, I'm not sure the :new.storm_pers_id would work on an UPDATE,
> since it may not be part of the update statement. And perhaps there's
even
> an easier way of doing this that I'm not aware of.
>
> I don't know if this will work or not. Could some one experienced help me
> out with what's right or wrong with this.
>
> I really appreciate it.
>
> Thanks,
>
> Richard..
>
>
> --
> Richard Billingsley
>
> Note: To reply via email replace "deadend.com" with "vbig.com" before
> sending.
>
>
Received on Thu Mar 09 2000 - 10:40:03 CST

Original text of this message

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