CODEWITHSUNDEEP
sqloracle-databaseoracle-apex
Mehreen
Mehreen

Reputation: 13

Oracle Apex ORA-00922: missing or invalid option

I tried creating a table on oracle apex but when I run it, it shows the following error: ORA-00922: missing or invalid option. Here's my code:

CREATE TABLE  "PROD_INDEX" 
   (    
       "PNO" NUMBER (4,0) NOT NULL ENABLE,
    "CATEGORY" VARCHAR(15) , 
    "PRODUCT" VARCHAR2(10), 
    "COUNTRY" VARCHAR2(9), 
    "BRAND" VARCHAR(10)), 
    "DATE" DATE, 
    "YEAR" NUMBER(4,0), 
    "COST" NUMBER(7,2), 
    "SALES" NUMBER(10,2), 
     PRIMARY KEY ("PNO") ENABLE
   )
/

So what could be the problem?

Upvotes: 0

Views: 1106

Answers (3)

RLOG
RLOG

Reputation: 630

Try this.

CREATE TABLE  "PROD_INDEX" 
   (    
    "PNO" NUMBER (4,0) PRIMARY KEY,
    "CATEGORY" VARCHAR(15) , 
    "PRODUCT" VARCHAR2(10), 
    "COUNTRY" VARCHAR2(9), 
    "BRAND" VARCHAR(10), 
    "DATE" DATE, 
    "YEAR" NUMBER(4,0), 
    "COST" NUMBER(7,2), 
    "SALES" NUMBER(10,2)
   )

Also, it is considered bad practice to name your columns after Oracle reserved words (e.g. date)

Upvotes: 0

Siddartha Kandukury
Siddartha Kandukury

Reputation: 21

Run the below statement.

CREATE TABLE "PROD_INDEX" 
(    
    "PNO" NUMBER (4,0) NOT NULL ENABLE,
    "CATEGORY" VARCHAR(15) , 
    "PRODUCT" VARCHAR2(10), 
    "COUNTRY" VARCHAR2(9), 
    "BRAND" VARCHAR(10), 
    "DATE" DATE, 
    "YEAR" NUMBER(4,0), 
    "COST" NUMBER(7,2), 
    "SALES" NUMBER(10,2), 
    PRIMARY KEY ("PNO") ENABLE
)

Upvotes: 1

Mehreen
Mehreen

Reputation: 13

CREATE TABLE  "PROD_INDEX" 
   (    
       "PNO" NUMBER (4,0),
    "CATEGORY" VARCHAR(15) , 
    "PRODUCT" VARCHAR2(10), 
    "COUNTRY" VARCHAR2(9), 
    "BRAND" VARCHAR(10)), 
    "DATE" DATE, 
    "YEAR" NUMBER(4,0), 
    "COST" NUMBER(7,2), 
    "SALES" NUMBER(10,2), 
     PRIMARY KEY ("PNO") ENABLE
   )

removed not null enable, and it works.

Upvotes: 0

Related Questions