Search code examples
sqloracle11gqsqltablemodelisqlquery

SQL Oracle Command "missing right parenthesis"


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)
);

Solution

  • 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