Interested to Buy Any Domain ? << Click Here >> for more details...
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
- 1 Answers
- 3458 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 is a lookup table in oracle?
How to put more than 1000 values into an oracle in clause?
How to convert csv to table in oracle?
What is bulk collect in oracle?
Explain the use of file option in exp command.
What are nested tables?
Explain the use of log option in exp command.
How to best split csv strings in oracle 9i?
What is Undo Management Advisor in Oracle?
Oracle
Explain cascading triggers.
How to start a specific oracle instance?
What is an Oracle Instance?
What is the simplest tool to run commands on oracle servers?
Is oracle an operator?
