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
- 3292 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
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to retrieve data from an explicit cursor?
Give the various rollback segment states.
What is a trigger and what are its types?
How to change system global area (sga) in oracle?
Explain coalesce function?
How to delete a user account in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the arithmetic operations?
Explain a synonym?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is tns entry?
Explain how you would restore a database using RMAN to Point in Time?
What are the differences between date and timestamp in oracle?
