Re: date function

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 CST