Error code in Oracle SQL?

Question

Here's the thing I'm trying to do with Oracle SQL.
CREATE TABLE options
(Ocode CHAR(4) PRIMARY KEY,
Odesc VARCHAR2(48),
Ocost NUMBER(7,2)
Olist NUMBER(7,2));

It spits out the following:
(Ocode CHAR(4) PRIMARY KEY,
*
ERROR at line 2:
ORA-00922: missing or invalid option

What's the issue here?

Answer 1

try this, it works i did a test run





CREATE TABLE options

(Ocode CHAR(4) primary key ,

Odesc VARCHAR2(48),

Ocost NUMBER(7,2),

Olist NUMBER(7,2));

Answer 2

Try this:





CREATE TABLE options

( Ocode CHAR(4) not null,

Odesc varchar2(48) not null,

Ocost Number(7,2),

Olist Number(7,2),

CONSTRAINT Ooptions_pk PRIMARY KEY (Ocode)

);

Answer 3

As it is wont to do, Oracle has its own way of doing some things. Instead of the PRIMARY KEY clause, just specify the column as NOT NULL and add a CONSTRAINT - PRIMARY KEY clause as one of the last statements in the CREATE TABLE. See http://techonthenet.com/oracle/primary_keys.php for particulars.