How to solve the problem of "ORA-00922: missing or invalid option" error?

Question

I entered the following SQL command in Oracle, but it reported the error "ORA-00922: Option is missing or invalid"

CREATE TABLE Student (
    StuID NUMBER(15),
    StuName VARCHAR2(50),
    Phone VARCHAR2(20),
    PRIMARY KEY (StuID))

CREATE TABLE Program (
    ProCode VARCHAR2(12),
    ProTitle VARCHAR2(50),
    PRIMARY KEY (ProCode))

Why? ? ?

Answer 1

创建表 Student (
    StuID     NUMBER(15),
    StuName   VARCHAR2(50),
    Phone     VARCHAR2(20),
    CONSTRAINT PK_STUID PRIMARY KEY (StuID))

Find the answer here here.

edit:

Also, try using / as statement separator instead of ;

Answer 2

If you are using OracleXE's horrible HTML GUI (inside the browser), then it does not support running multiple statements.

Please use SQL Developer, SQL*Plus or any other GUI tool instead.