SQL Oracle Command "missing right parenthesis"

71 Views Asked by At

every time I want to create this table, it says Missing Right Parenthesis. Can someone please check what i have wrong please. Thank you

CREATE TABLE Pet
(
PetID Int NOT NULL PRIMARY KEY,
OwnerID Char (7) NOT NULL,
TypeID Char integer NOT NULL,
PetName Char (30),
Description Char (50),
Birthday VarChar (255),
LastVisit VarChar (255)
);
1

There are 1 best solutions below

0
On BEST ANSWER
CREATE TABLE Pet 
(
PetID Int NOT NULL PRIMARY KEY,
OwnerID Char (7) NOT NULL,
TypeID Char NOT NULL,
PetName Char (30),
Description Char (50),
Birthday VarChar (255),
LastVisit VarChar (255)
);

Check this column data type Char Or Integer - TypeID