Thread: create table help

create table help

From
"srs2000"
Date:
hi im new to sql, and i am trying to use sqlplus.

here's the table im trying to create

create table CUSTOMER

(CUST_NAME varchar2 (14),

CUST_DOB date,

CUST_ADDRESS varchar2 (25)

CUST_TELNO varchar2 (15)

primary key (CUST_NAME, CUST_ADDRESS));



this is the error message i get:

ERROR at line 2:
ORA-00922: missing or invalid option



any suggestion or help, would be much appriciated.




Re: create table help

From
Doug McNaught
Date:
"srs2000" <srs2000_uk@yahoo.com> writes:

> this is the error message i get:
>
> ERROR at line 2:
> ORA-00922: missing or invalid option

This is not an Oracle list.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863