Confusing error about missing left parenthesis in SQL statement

Question

SQLPLUS says I have missing left parenthesis with this statement in my sql script..

CREATE TABLE people(
    id INT NOT NULL PRIMARY KEY,
    name VARCHAR2
);

I had uploaded my script with sftp, could that have played around with the script?

Answer 1

VARCHAR2 is a type that needs a maximum size/length. Try something like...

varchar2(50)

Your missing left parenthesis is the parenthesis that surrounds the size.

CREATE TABLE people(
    id INT NOT NULL PRIMARY KEY,
    name VARCHAR2(50) 
);