emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
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 |
Does rowid change in oracle?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
How to use existing values in update statements using oracle?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
How to initialize variables with default values?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
How to view all columns in an existing table?
How to experiment a data lock in oracle?
what is reindexing?
what is the syntax of UPDATE command?
What happens if you lost a data file?