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.

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1080

---

What is sql in java?

1132

---

Differentiate between syntax and runtime errors.

1232

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1104

---

Inline the values in PL/SQL, what does it mean.?

1271

---

What is Materialized View? In What Scenario we Use Materialized View?

9614

---

What is difference between stored procedure and trigger?

1239

---

Why having clause is used in sql?

1017

---

Can we commit in trigger?

1025

---

Can we create foreign key without primary key?

1036

---

What does closing a cursor do?

1372

---

What is a primary key called that is made up of more than one field?

1393

---

Is primary key a clustered index?

1008

---

Which join condition can be specified using on clause?

1008

---

What is output spooling in sql*plus?

1087

---