Re: Alter table add question

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Sat, 5 Feb 2000 21:30:31 -0600
Message-ID: <MPG.1306a6d0ee03027e98972f@nntp.ce.mediaone.net>

In article <0rHm4.4465$oU2.902500_at_tw12.nn.bcandid.com>, mjames_at_jsifrs.com says...
> I want to do this:
> alter table gifts add
> giftdiscod char(6) null,
> giftdiscnt number(16,2) default 0 not null;

You forgot the parenthesies (however you spell that word).

alter table gifts add
( giftdiscod char(6),
  giftdiscnt number(16,2) default 0 not null);

HTH; Doug

--

---

Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net

---

Received on Sat Feb 05 2000 - 21:30:31 CST