Re: Timestamping records automatically

Arch wrote:
> I need to add a date / time stamp to records as they are inserted into
> a table. I need to do this at the server end.
>
> Is there a "correct" way to do that? Should I simply use a default
> value of sysdate? Or should this be done with a trigger or something
> else?
>
> Thanks for any advice

CREATE TABLE t (
col1 VARCHAR2(20),
col2 DATE DEFAULT SYSDATE);

INSERT INTO t
(col1)
VALUES
('AAA'); SELECT * FROM t;

Documented in Morgan's Library at www.psoug.org under HEAP TABLES.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org