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)
......
and so on .
If you already have a table in place then you can you the following to change
the defaults:
alter table x MODIFY(
operator varchar2(30) default user,
created_on date default sysdate)
......
and so on .
Hope this is of some help.
Received on Thu Sep 03 1998 - 06:50:53 CDT
