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: Alter table add question

Re: Alter table add question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 4 Feb 2000 22:52:54 +0100
Message-ID: <949701305.27339.0.pluto.d4ee154e@news.demon.nl>


It's ( column data_type [not null] , column data_type [not null] ) etc

Hth

--
Sybrand Bakker, Oracle DBA
JSI FundRaising R&D Group <mjames_at_jsifrs.com> wrote in message news:0rHm4.4465$oU2.902500_at_tw12.nn.bcandid.com...
> We are adding columns to every table in our database. I am having trouble
> getting the syntax to allow me to add multiple columns in one statement.
> Can anybody tell me what I am doing wrong or is this something you can't
do
> in Oracle. Here is an example.
>
> I want to do this:
> alter table gifts add
> giftdiscod char(6) null,
> giftdiscnt number(16,2) default 0 not null;
>
> I had to do this to get it to work:
> ALTER TABLE gifts ADD (giftdiscod char(6) null);
> ALTER TABLE gifts ADD (giftdiscnt NUMBER(16,2) DEFAULT 0 NOT NULL);
>
> Michaele James
> JSI FundRaising Systems
> Senior Programmer/Analyst
>
>
Received on Fri Feb 04 2000 - 15:52:54 CST

Original text of this message

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