How to create a table using constraints...
IF i change the PARENT KEY value ,then CHILD KEY
table will also to change in the another table...

plz reply ur answers @ mak2786@gmail.com

Arunkumar

Answers were Sorted based on User's Feedback



How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table..

Answer / 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.

Is This Answer Correct ?    1 Yes 3 No

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table..

Answer / deepak singh

RAISE AN INEGRITY CONSTAINT ERROR(ORA-02292)

Is This Answer Correct ?    0 Yes 3 No

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table..

Answer / alien

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)

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is sorting in sql?

0 Answers  


can we create index on index?

7 Answers   iFlex, Symphony,


What is varchar data type in sql?

0 Answers  


suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,


How do you add a column to a table?

0 Answers  






What is a dynamic query?

0 Answers  


If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  


How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,


Which sql most popular?

0 Answers  


What is sql analyzer?

0 Answers  


Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  


Is it possible to read/write files to-and-from PL/SQL?

0 Answers  


Categories