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
- 3391 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 |
why can't we assign not null constraint as table level constraint
how to get second highest sal of emp table
What is the Extension of Oracle Database? As extension of Access Database is .mdb
How to define a record variable to store a table row?
How to create additional tablespaces for an new database?
What is a subquery?
What are a collation and state the different types of collation sensitivity?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
What are data pump export and import modes?
What is index-organized table in Oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to use "in out" parameter properly?
Oracle General 
