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


Please Help Members By Posting Answers For Below Questions

How do I count rows in sql?

649


What is nosql vs sql?

683


How to install oracle sql developer?

668


Explain the difference between triggers and constraints?

607


what are local and global variables and their differences? : Sql dba

622






what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

651


Is sql considered coding?

665


What is normalization? How many normalization forms are there?

649


What are sql functions? Describe the different types of sql functions?

636


What is record variable?

637


What is the difference between inner join and left join?

623


Is grant a ddl statement?

535


Can triggers stop a dml statement from executing on a table?

699


What is the sql query to display the current date?

638


Why we use sql profiler?

644