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
- 3389 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
How to change program global area (pga) in oracle?
How to load excel data sheet to oracle database
What is coalesce function?
What are the different types of record groups in oracle? Explain each of them
How to check the server version in oracle?
How do I reset a sequence in oracle?
Explain an exception?
How to work with data objects interactively?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is normalisation?what are its uses?
What is partitioned table in Oracle?
How to select all columns of all rows from a table in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What happens to indexes if you drop a table?
What happens if you set the sga too low in oracle?
