Naw, I'm not using db2.
i am trying to indoctrinate myself to oracle BUT,
i am taking the sql command -line approach vs. using
a dbms specific user interface. I have another newbie type ques, i
ask w/a fresh post...Thanks!
<www_dba_at_my-deja.com> wrote in message
news:81vq25$rb2$1_at_nnrp1.deja.com...
> Hi,
>
> Try switching positions of DEFAULT expr and column constraints.
>
> BTW, are you DB2 user?
>
> HTH.
>
> In article <81un7c$d61$1_at_autumn.news.rcn.net>,
> "Lee Gold" <leegold_at_nospam.com> wrote:
> > I am using: SQL*Plus: Release 3.3.4.0.0
> > and Personal Oracle 7.3.4, Win95
> >
> > the following statement not working, I show it below w/error
message
> :
> >
> > SQL> CREATE TABLE PENALTIES_DEFAULT
> > 2 (PAYMENTNO INTEGER NOT NULL,
> > 3 PLAYERNO SMALLINT NOT NULL,
> > 4 PEN_DATE DATE NOT NULL DEFAULT '01-JAN-90',
> > 5 AMOUNT DECIMAL(7,2) NOT NULL DEFAULT 50.00);
> > PEN_DATE DATE NOT NULL DEFAULT '01-JAN-90',
> > *
> > ERROR at line 4:
> > ORA-00907: missing right parenthesis
> >
> > btw, i got this statement from "The SQL Guide to Oracle", by van der
> > Lans
> > it may be erratta since the book was written for Oracle6, and the
> author
> > notes that the implementation for DEFAULT may change for later
> versions.
> >
> > What's wrong here? THANKS, LeeGold
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 30 1999 - 01:03:15 CST
