Answer / nitin

With the use of forward declaration we can call other package

Answer / subha

First compile package A and B spec then compile package body of both A and B.

Answer / 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)

Answer / nitin

Forward declaration can be implemented for procedure only.In one package you can create inter-dependency but for package it is not possible.

Answer / anil

I assume this question as:
") I have 2 programs  A and B. Now program A references Program  B and Program B references Program A. How do you compile such inter-dependent objects in PL/SQL"

ANS:We can compile mutually referencing programmes using FORWARD declaration(specifying the declaration of one program in beginning of package body) inside a PACKAGE.
Example:
CREATE OR REPLACE PACKAGE test_pack
IS
gvar NUMBER:=0;
--PROCEDURE p1; --we can also achieve like this
END;
/

CREATE OR REPLACE PACKAGE BODY test_pack
IS
PROCEDURE p1; --forward declaration

PROCEDURE p2 
IS
BEGIN
P1;
END;

PROCEDURE p1
IS
BEGIN
p2;
END;

END;

How do I create a memory optimized filegroup?

0 Answers  

What is sql trigger example?

0 Answers  

what is 'mysqlcheck'? : Sql dba

0 Answers  

What are the advantages of normalization?

0 Answers  

How to pipe multiline string to isql?

0 Answers  

what are integrity rules?

0 Answers  

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

What is trigger in flip flop?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

What is nested table in pl sql?

0 Answers  

What are the disadvantages of not performing database normalization?

0 Answers