CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle11g
ทักษกร นิลดำ
ทักษกร นิลดำ

Reputation: 37

building table but get "missing right parenthesis"

I try to build this table

 CREATE TABLE OFFICER 
(
ID int(8) PRIMARY KEY,
FIRST_NAME varchar2(20) NOT NULL,
LAST_NAME varchar2(20) NOT NULL,
HIRE_DATE date NOT NULL,
UNHIRE_DATE date,
SALARY int(7),
PHONE_NUMBER int(10),
TYPE varchar2(15) NOT NULL
);

Do I have to use any constraint, reference? and What I lack for this code?

Upvotes: 0

Views: 64

Answers (2)

Dba
Dba

Reputation: 6639

Try this,

CREATE TABLE OFFICER 
(
ID NUMBER(8) PRIMARY KEY,
FIRST_NAME varchar2(20) NOT NULL,
LAST_NAME varchar2(20) NOT NULL,
HIRE_DATE date NOT NULL,
UNHIRE_DATE date,
SALARY NUMBER(7),
PHONE_NUMBER NUMBER(10),
TYPE varchar2(15) NOT NULL
);

Upvotes: 0

Kirill Leontev
Kirill Leontev

Reputation: 10941

INT data type doesn't allow scale specification. Try either ID int primary key or Id NUMBER(8) primary key.

Upvotes: 1

Related Questions