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
- 3460 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 |
what are pseudocolumns?
How to add a new column to an existing table with a default value?
What are ddl statements in oracle?
What are the various constraints used in oracle?
How to add another datafile to a tablespace?
How to create index-by table in oracle?
what are the advantages of running a database in NO archive log mode?
What are inner join and outer join?
State and explain the different types of data models?
Explain alias?
Why do we use bulk collect in oracle?
Can you assign multiple query result rows to a variable?
Oracle General 
