Re: newbie SQL question

From: <www_dba_at_my-deja.com>
Date: Tue, 30 Nov 1999 06:15:37 GMT
Message-ID: <81vq25$rb2$1@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 - 00:15:37 CST