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
- 3314 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is raw datatype?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
how may join possible between (requisition with purchase order)
How to get execution path reports on query statements?
What is merge in oracle?
Differentiate between pre-select and pre-query?
How to use "in out" parameter properly?
What is oracle and what are its different editions?
Explain the use of inctype option in exp command.
What do you understand by a database object?
Explain oracle data types with examples?
How to export several tables together?
Why do we need integrity constraints in a database?
Explain the use of tables option in exp command.
How to bring a tablespace offline?
