emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
- 1 Answers
- 2668 Views
- I also Faced
- E-Mail Answers
Answer Posted / vilas
Foregin key: It is the relation between two tables.it can be
used to create the relation between two tables,when two
tables have the unique rows (means emp_numb)then we can
used to foreign key.
eg:
create table student
{ name varchar(10),
rollno int(10));
.......this is student table........
create table student_Details
{ name varchar(10),
rollno int(10)refercence
);
.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What operating systems are supported by oracle database 10g xe?
What is a trace file and how is it created in oracle?
Is the After report trigger fired if the report execution fails ?
How many types of auditing in Oracle?
What is enter substitution variable in oracle?
Explain the use of ignore option in imp command.
What happens to indexes if you drop a table?
How to select some rows from a table in oracle?
When do you get a .pll extension in oracle? Explain its importance
How to set a transaction to be read only in oracle?
Can you have more than one content canvas view attached with a window ?
How oracle handles dead locks?
What are the execution control statements in oracle?
interview questions with answer for cts
What is using clause and give example?
