emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
- 1 Answers
- 2680 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
Why we use bulk collect in oracle?
Which are the five query types available in oracle?
How to assign query results to variables?
How to insert a record into a table?
How to use null as conditions in oracle?
How to retrieve values from data fields in record variables?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is a nvl function? How can it be used?
What is an oracle?
How to define and use table alias names in oracle?
How to store only time; not date and time?
What is set verify off in oracle?
Explain index?
How to add a new column to an existing table in oracle?
What is hash cluster in oracle?
