Re: Alter table add question

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