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
- 3401 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 |
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is COST-based approach to optimization ?
Is truncate autocommit in oracle?
How to pass a parameter to a cursor in oracle?
what is cartesian product?
What is columnar storage what is the advantage?
What is a proxy object?
what is difference between where clause and having clause?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How can I get column names from a table in oracle?
What is Undo Management Advisor in Oracle?
How to invoke the data pump export utility?
Oracle General 
