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;

What are the syntax and use of the coalesce function?

1205

---

Can we insert data in view?

963

---

Does mysql support pl sql?

1172

---

Explain the uses of control file.

1050

---

In what condition is it good to disable a trigger?

1011

---

Can we have two clustered index on a table?

1025

---

What is materialized view. What are different methods of refresh?

1393

---

What is the difference between Union and Union all. Which is faster.

1402

---

What is the execution plan in sql?

1022

---

How to make a copy values from one column to another in sql?

1037

---

How do I view tables in mysql?

985

---

what is a join? : Sql dba

1035

---

What is the size of partition table?

1048

---

How to Execute a Package in PL/SQL.?

1203

---

Which is faster view or stored procedure?

946

---