Re: date function
From: Robin Quasebarth <robinq_at_data-point.com>
Date: 1998/11/04
Message-ID: <36406D7B.81F4794_at_data-point.com>#1/1
Date: 1998/11/04
Message-ID: <36406D7B.81F4794_at_data-point.com>#1/1
Use a database trigger like:
CREATE or REPLACE TRIGGER dbtrig_1
BEFORE INSERT or UPDATE on employees
FOR EACH ROW
begin
:new.current_date := sysdate ;
end;
/
CB wrote:
> I am trying to insert the "current date" into a column for each record
> inserted or updated into a given table. Does anybody know if is amy
> function in Oracle I can use for this task?
>
> cornel
Received on Wed Nov 04 1998 - 00:00:00 CET