Re: how to create a trigger.

From: cf <news_at_tolede.com>
Date: Mon, 25 Oct 2004 18:29:35 +0200
Message-ID: <417d29f2$0$5455$4d4eb98e@read.news.fr.uu.net>

CREATE OR REPLACE TRIGGER TS_TABLE1 BEFORE INSERT OR UPDATE ON TABLE1 FOR EACH ROW BEGIN :NEW.TIMESTAMP := SYSDATE; END;
/
Christophe.

"Max via OracleMonster.com" <forum_at_OracleMonster.com> a écrit dans le message de news:88282fa0641b46ab8a7ea744de7ed730_at_OracleMonster.com...
> Hi all,
>
> how to create a trigger on a table when create or update a row in a table
(xxx).
> I need for set a column to set SYSDATE.
> Can you give me un example?
>
> thanks all.
>
> *****************************************
> * This message was posted via http://www.oraclemonster.com
> *
> * Report spam or abuse by clicking the following URL:
> *

http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=88282fa0641b46ab8a7ea744de7ed730
> *****************************************
Received on Mon Oct 25 2004 - 11:29:35 CDT