Re: Timestamping records automatically

On Sat, 06 Oct 2007 00:16:53 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>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.

Thanks, Daniel. I had searched Morgan's library earlier but missed it under Heap Tables. Received on Sat Oct 06 2007 - 15:09:26 CDT