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 are the types of variables use in pl sql?
What is difference between primary and secondary key?
what happens if null values are involved in expressions? : Sql dba
How much does a sql dba make? : SQL DBA
Which operator is used in query for pattern matching?
Name some usages of database trigger?
How to display the current date in sql?
What is memory optimized?
Can we change the table name in sql?
Does sql support programming?
List the various privileges that a user can grant to another user?
How do you use join?
Which is faster union or join?
what are the different index configurations a table can have? : Sql dba
Why do we use joins?