Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Timestamp of a record

Re: Timestamp of a record

From: Frank <fbortel_at_nescape.net>
Date: Thu, 11 Dec 2003 22:39:25 +0100
Message-ID: <branlp$5c8$1@news3.tilbu1.nb.home.nl>


Jeff Smith wrote:

> ALTER TABLE <table_name>
>

>>ADD <column_name> TIMESTAMP DEFAULT SYSTIMESTAMP;

>
>
>
> Is this something new? ... I am using 8.1.7
>
> SQL> ALTER TABLE eraseme ADD (newcol1 TIMESTAMP DEFAULT SYSTIMESTAMP);
> ALTER TABLE eraseme ADD (newcol1 TIMESTAMP DEFAULT SYSTIMESTAMP)
> *
> ERROR at line 1:
> ORA-00984: column not allowed here
>
> I use:
> alter table eraseme add( newcol date default sysdate)
> Table altered.
>
>

No - you're old ;-) Since 9i Rel 1

-- 
Regards, Frank van Bortel
Received on Thu Dec 11 2003 - 15:39:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US