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
- 3289 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 is different types of joins?
How to assign a tablespace to a users in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to connect to a local oracle 10g xe server?
What is a materialised view?
what are different types of deletes?
what is the difference between simple view and complex view?
How to best split csv strings in oracle 9i?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What are the oracle built-in data types?
How to unlock the sample user account in oracle?
What is oracle thin client?
Oracle General 
