Re: create table question

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1997/11/21
Message-ID: <347663C7.2B48@deere.com>#1/1

drichardson wrote:
>
> Hello,
>
> I am new to Oracle and I need to create a simple table, but when I create
> the table I get an invalid object (I think) error in line 3:
>
> create table SALESOUT (
> 2 Disti CHAR(50),
> 3 Date DATE,
> 4 Period NUMBER,
> 5 Sales Out NUMBER(9,2),
> 6 Bookings NUMBER(9,2),
> );
>
> Can someone look at my code and tell me if it is incorrect?
>
> much appreciated,
>
> Dave

Date is a reserved word in Oracle and cannot be used as a column name. Received on Fri Nov 21 1997 - 00:00:00 CST