emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
- 1 Answers
- 2656 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Find all employees in Dept “Marketing”.
Explain the importance of .pll extension in oracle?
What are the uses of linked server and explain it in detail?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
what are stored procedures?
which sql command we can use to get a print out from oracle?
What is the data pump export utility?
Can we store images in oracle database?
What are advantages of dateset in datastage?
What is the disadvantage of User defind function?
what is the difference between restoring and recovering?
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
Oracle General 
