SQL> CREATE TABLE Faculty(
2 FacSSN char( 11 ) NOT NULL ,
3 FacFirstName varchar( 50 ) NOT NULL ,
4 FacLastName varchar( 50 ) NOT NULL ,
5 FacCity varchar( 50 ) NOT NULL ,
6 FacState char( 2 ) NOT NULL ,
7 FacZipCode char( 10 ) NOT NULL ,
8 FacHireDate date,
9 FacDept char( 6 ) ,
10 FacRank char( 4 ) ,
11 FacSalary decimal( 10, 2 ) ,
12 FacSupervisor char( 11 ) ,
13 CONSTRAINT PKFaculty PRIMARY KEY ( FacSSN ) ,
14 CONSTRAINT FKFacSupervisor FOREIGN KEY ( FacSupervisor )
REFERENCES Faculty( FacSSN ) ON DELETE
SET NULL ON UPDATE CASCADE
15 );
CONSTRAINT FKFacSupervisor FOREIGN KEY ( FacSupervisor ) REFERENCES
Faculty( FacSSN ) ON DELETE SET
ERROR at line 14:
ORA-00907: missing right parenthesis
SQL>
오른쪽 괄호가 빠졌다는데...
아마도 "ON DELETE SET NULL ON UPDATE CASCADE"
이 부분에서 에러인데 오라클에서 저렇게 쓸 수 없나요?
|