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

What are the types of variables use in pl sql?

686


What is difference between primary and secondary key?

732


what happens if null values are involved in expressions? : Sql dba

734


How much does a sql dba make? : SQL DBA

666


Which operator is used in query for pattern matching?

831






Name some usages of database trigger?

742


How to display the current date in sql?

773


What is memory optimized?

745


Can we change the table name in sql?

698


Does sql support programming?

763


List the various privileges that a user can grant to another user?

770


How do you use join?

700


Which is faster union or join?

702


what are the different index configurations a table can have? : Sql dba

741


Why do we use joins?

771