I have 2 packages A and B. Now package A references Package B
and Package B references Package A. How do you compile such
inter-dependent objects in PL/SQL
Answer Posted / ss
i know sql so here A and B are two tables which both having Primary and foreign Key so from A's PK is referring in to B and B's PK referring in to A
OR select * from A inner join B on (A.id=B.AID)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is sql prepared statement?
Can a table have no primary key?
What are the different parts of a package?
what is a control file ? : Sql dba
What does an inner join do?
What is the difference between partition and index?
How can I see all tables in sql?
What is the use of primary key?
What is trigger with example?
Can we rollback truncate?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is pls integer?
What is error ora-01000: maximum open cursors exceeded
What information is needed to connect sql*plus an oracle server?
Can we insert data into view?