For example, if i delete/update a record from the employee table, the other tables that are referenced to it will be updated/deleted
Here is the database create SQL i have
Expand|Select|Wrap|Line Numbers
- CREATE TABLE Employee (
- ssn NUMBER (4) PRIMARY KEY,
- salary NUMBER (5),
- phone NUMBER (11)
- );
- CREATE TABLE Department (
- dno NUMBER (1) PRIMARY KEY,
- dname VARCHAR2 (20),
- budget NUMBER (6)
- );
- CREATE TABLE Child (
- name VARCHAR2 (20) UNIQUE,
- age NUMBER (2),
- check(age BETWEEN 0 AND 18)
- );
- CREATE TABLE Children (
- ssn NUMBER (4),
- name VARCHAR2 (20),
- CONSTRAINT emp_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT chd_FK FOREIGN KEY(name) references Child(name) ON DELETE SET NULL ON UPDATE CASCADE
- );
- CREATE TABLE Works (
- ssn NUMBER (4),
- dno NUMBER (1),
- CONSTRAINT empl_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT dept_FK FOREIGN KEY(dno) references Department(dno) ON DELETE SET NULL ON UPDATE CASCADE
- );
- CREATE TABLE Manages (
- ssn NUMBER (4),
- dno NUMBER (1),
- CONSTRAINT employ_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT depart_FK FOREIGN KEY(dno) references Department(dno) ON DELETE SET NULL ON UPDATE CASCADE
- );
- CREATE TABLE NewMember (
- ssn NUMBER (4),
- dno NUMBER (1)
- );
ORA-00907: missing right parenthesisand it points to these lines
Expand|Select|Wrap|Line Numbers
- CONSTRAINT emp_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE,
- CONSTRAINT empl_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE
- CONSTRAINT employ_FK FOREIGN KEY(ssn) references Employee(ssn) ON DELETE SET NULL ON UPDATE CASCADE