Answer Posted / 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 many tables will create when we create table, what are they? : Sql dba

1069

---

How does a trigger work?

1063

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

969

---

What is a constraint?

1016

---

Why is a trigger used?

937

---

How do you exit in sql?

1106

---

How many clustered indexes can be created on a table?

1073

---

what are the nonstandard string types? : Sql dba

1134

---

What mean sql?

1001

---

Explain about various levels of constraint.

944

---

what is the difference difference between procedure and packages

10393

---

What are different functions in sql?

940

---

Is sql pronounced sequel or sql?

1260

---

What is trigger explain it?

1011

---

what is online transaction processing (oltp)? : Sql dba

992

---