Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inserts with automatic time stamp
Hi,
I dont whether you know about this, but if you are wanting to store
date and time on every NEW record then you can do the following when creating
the table :
create table x(
operator varchar2(30) default user, created_on date default sysdate)
operator varchar2(30) default user, created_on date default sysdate)
Hope this is of some help. Received on Thu Sep 03 1998 - 06:50:53 CDT