hi, i got this missing right parenthesis error while trying to create a table
and i'm not too sure where i went wrong
could someone point out my mistakes?
this is what i had typed into Oracle SQL developer
CREATE TABLE PROPERTYFORRENT
(PROPERTYNO VARCHAR2(5) NOT NULL,
STREET VARCHAR2(25) NOT NULL,
AREA VARCHAR2(15),
CITY VARCHAR2(15) NOT NULL,
POSTCODE VARCHAR2(8),
TYPE CHAR NOT NULL,
ROOMS BYTE,
RENT VARCHAR2(6, 2),
OWNERNO VARCHAR2(5),
STAFFNO VARCHAR2(5),
BRANCHNO VARCHAR2(5) NOT NULL,
CONSTRAINT PROPERTYNO PRIMARY KEY (PROPERTYNO),
CONSTRAINT OWNERFK FOREIGN KEY(OWNERNO) REFERENCES OWNER(OWNERNO),
CONSTRAINT STAFFFK FOREIGN KEY(STAFFNO) REFERENCES STAFF(STAFFNO),
CONSTRAINT BRANCHFK FOREIGN KEY(BRANCHNO) REFERENCES BRANCH(BRANCHNO));
much thanks.