Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between foreign key and reference key
- 3 Answers
- 42116 Views
- AZTEC, Infosys, I also Faced
- E-Mail Answers
Answer Posted / anup
very simple...we use primary key or foreign key whenever we need to make relation.ex..if we need to join student (Roll P.K) and marks(roll F.K.) then we can join both tables only if we have primary key in one table and foreign key in other..one table may have n numbers of foreign key and n number of primary key (Called composite key)..mail me if u need more details in oracle or any front end lang...anup from chennai,Ranchi.
| Is This Answer Correct ? | 8 Yes | 27 No |
Post New Answer View All Answers
can u plz provide me oca sql dumps please i need them
How to create a stored program unit?
What is recovery manager(rman) backup in Oracle?
Where do we use decode and case statements?
What is the implicit cursor in oracle?
How to rename a column in an existing table?
What is the difference between formal parameters and actual parameters?
Can you assign multiple query result rows to a variable?
What does sharding mean?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is materialized view in Oracle?
How to set up autotrace for a user account?
Explain the use of record length option in exp command.
How to create a new tablespace in oracle?
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.
