Alter table add question

From: JSI FundRaising R&D Group <mjames_at_jsifrs.com>
Date: Fri, 04 Feb 2000 21:23:09 GMT
Message-ID: <0rHm4.4465$oU2.902500@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:23:09 CST