CREATE TABLE VENUE (
VenueName VARCHAR2(100) CONSTRAINT VenuePK PRIMARY KEY,
Location VARCHAR2(255) NOT NULL,
Capacity NUMBER(10) NOT NULL,
);
It looks like you're trying to create a SQL table named VENUE
. However, there is a small syntax error in your SQL statement. Specifically, there is an extra comma after the last column definition. Here’s the corrected version of your SQL statement:
CREATE TABLE VENUE (
VenueName VARCHAR2(100) CONSTRAINT VenuePK PRIMARY KEY,
Location VARCHAR2(255) NOT NULL,
Capacity NUMBER(10) NOT NULL
);
Make sure to execute this corrected SQL statement in your database environment to create the VENUE
table successfully.