On May 10, 6:16 am, manish sahu <manish.com...@gmail.com> wrote:
> there are two tables
>
> 1. EMPLOYEE(eid,ename,sal,job,deptno)
> 2. DEPT(dno,dname,location)
>
> for EMPLOYEE table primary key is eid and deptno is foreign key
> which refers DEPT's dno.
> for DEPT primary key is dno
>
> FOR above two tables plz tell me which is FOREIGN TABLE
> and which is PRIMARY TABLE
No such designations exist.
If you are actually asking which is the Parent table and which is the
Child table that distinction should be obvious if you understand
primary and foreign keys. Which table has a foreign key constraint
(child table)? Which table does that constraint reference (parent
table)?
Answer those questions and you answer your own.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
