hali

SQL> alter session set nls_Date_format='HH24:MI:SS';Session altered.SQL> select * from p;        ID A          D---------- ---------- --------         1 test       21:05:19SQL> host cat t_test.sqlCREATE OR REPLACE TRIGGER d_trigBEFORE UPDATE ON pFOR EACH ROWBEGIN        select sysdate into :new.d from dual;END d_trig;/SQL> @t_testTrigger created.SQL> update p set a='foo';1 row updated.SQL> select * from p;        ID A          D---------- ---------- --------         1 foo        21:08:43SQL> commit;Commit complete.SQL>