Hi everybody, Create table statement in SQL not working!

oracle

I am a newbie to DBA and I am trying to create a table of vendors and products. Vendor_Name in second line is underlined and when I hover the cursor over it, it shows me a window of error syntax with different lines and I do not understand what they are. After running I receive an error of ORA-00906 "missing left parenthesis."

Create Table Vendor (
Vend_ID VARCHAR2(3) NOT NULL, Primary Key
Vendor_Name VARCHAR(50) NOT NULL,
Vendor_ST VARCHAR(25) NOT NULL,
);

I appreciate any help!

Best Answer

Attention to details is important. Go back to first principles (syntax) if stuck.

Create Table Vendor (
Vend_ID VARCHAR2(3) NOT NULL primary key,
Vendor_Name VARCHAR(50) NOT NULL,
Vendor_ST VARCHAR(25) NOT NULL
);

fiddle