Click here to Skip to main content
15,880,608 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
ORA-00922: missing or invalid option
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 673
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 659
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 1855


4. Semester VARCHAR2(15) NOT NULL,     
5. Group_Class VARCHAR2 (5) NOT NULL,
6. Total_Offer NUMBER(10));


What I have tried:

CREATE TABLE OFFERED COURSES
(Offered_Courses_ID NUMBER(15) CONSTRAINT Offered_Courses_ID_pk PRIMARY KEY,
Course_Name VARCHAR2(50) NOT NULL,     
Semester VARCHAR2(15) NOT NULL,     
Group_Class VARCHAR2 (5) NOT NULL,
Total_Offer NUMBER(20) NOT NULL);
Posted
Updated 10-Jul-21 6:30am
v2
Comments
Patrice T 10-Jul-21 12:01pm    
And the server says something ?

1 solution

You can not have a space in the table name, so use this instead:
CREATE TABLE OFFERED_COURSES

And even better, use one of these: relational-databases[^]
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900