Re: Beginner create table question

drichardson wrote:
>
> Hello,
>
> I am new to Oracle and I need to create a simple table, but when I attempt
> to create the table I get an invalid object (I think its object) 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, I would really
> appreciate it.
>
> Thanks in advance,
>
> Dave

Hi, I am kind of new too, but I think I got it. I believe that "date" is a reserved word, so try "date_created" instead. Also, you will need to change line 5 to "sales_out". "sales 'space' out" will cause and error too. Also you don't need the ',' at the end of line 6 (also causes and error).

Hope this helps. Received on Mon Nov 24 1997 - 00:00:00 CST