CREATE TABLE DEPARTMENT (

DEPT_ID CHAR(4),

DEPT_NAME VARCHAR2(10),

CH_ID CHAR(4),

CONSTRAINT DEPARTMENT_PK PRIMARY KEY (DEPT_ID),

CONSTRAINT FK_CITYHALL FOREIGN KEY (CH_ID) REFERENCES CITYHALL(CITYHALL_ID) on delete restrict

);

FK_CITYHALL 조건 뒤에 on delete 나 on update 를 덧붙이면 오류가 뜨는데 왜 그런걸까요?

답변해주시면 감사하겠습니다...