Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

basic concept of spl

781692Aug 5 2010 — edited Aug 5 2010
hi all,
i have confusion with the following.
let me say i have table called 'A' which is having columns 'company' and 'reference' which are primary key of the table 'A'. I have one more table called 'B' which is having same columns 'company' and 'reference' which are primary keys of 'A' and foreign keys of 'B'.
consider i am passing value to the column 'reference'.
please clear me what results may i get if i joined to tables and what will happen if i pass the value only to the table 'B'.

please clear me.

Thanks..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 2 2010
Added on Aug 5 2010
1 comment
603 views