Answer Posted / rameshwari

Hi,
You can use cascade as follows
1>
2> CREATE TABLE employee (emp_no INTEGER NOT NULL
CONSTRAINT prim_empl PRIMARY KEY,
3> emp_fname CHAR(20) NOT NULL,
4> emp_lname CHAR(20) NOT NULL,
5> dept_no CHAR(4) NULL)
6>
7> CREATE TABLE project (project_no CHAR(4) NOT NULL
CONSTRAINT prim_pro PRIMARY KEY,
8> project_name CHAR(15) NOT NULL,
9> budget FLOAT NULL)
10>
11> CREATE TABLE works_on1
12> (emp_no INTEGER NOT NULL,
13> project_no CHAR(4) NOT NULL,
14> job CHAR (15) NULL,
15> enter_date DATETIME NULL,
16> CONSTRAINT prim_works1 PRIMARY KEY(emp_no,
project_no),
17> CONSTRAINT foreign1_works1 FOREIGN KEY
(emp_no) REFERENCES employee(emp_no) ON DELETE CASCADE,
18> CONSTRAINT foreign2_works1 FOREIGN KEY
(project_no) REFERENCES project(project_no) ON UPDATE
CASCADE)
19>
20> -- The creation of the works_on1 table that uses the ON
DELETE CASCADE and ON UPDATE CASCADE options.

Does pl/sql support create command?

1113

---

how to fetch common records from two tables? : Sql dba

1176

---

What is sql not null constraint?

1042

---

what is a database lock ? : Sql dba

1175

---

what is 'mysqlshow'? : Sql dba

1028

---

Is sql port 1433 encrypted?

1029

---

Define join and name different types of joins?

1008

---

Define tables and fields in a database

1135

---

How do I view a procedure in sql?

978

---

how to convert dates to character strings? : Sql dba

1174

---

What is the difference between truncate and drop statements?

1190

---

define data blocks ? : Sql dba

1000

---

How many triggers can be applied to a table?

1066

---

What is the requirement of self-join?

1133

---

what is an index? : Sql dba

999

---