newbie SQL question

From: Lee Gold <leegold_at_nospam.com>
Date: Mon, 29 Nov 1999 15:21:28 -0500
Message-ID: <81un7c$d61$1@autumn.news.rcn.net>

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 Received on Mon Nov 29 1999 - 14:21:28 CST