Answer Posted / venkat

A forward declaration looks like the package definition
part but is inside the bode.

e.g.

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;

will not work, because during call to B B is still unknown
(1 Step compiler) therefore we need a forward declaration:

procedure B;

procedure A is
begin
B;
end A;

procedure B is
begin
null;
end B;


now we can compile

Does sql use python?

559

---

When should I use nosql database?

551

---

What is Materialized View? In What Scenario we Use Materialized View?

8515

---

What is parameter substitution in sql?

523

---

What is the difference between joins?

534

---

---

What is the size of partition table?

551

---

How many commands are there in sql?

545

---

What is sql select statement?

503

---

How to move files from one directory to another in pl sql?

642

---

What are the types of sql commands?

548

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

547

---

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

844

---

Is pl sql different from sql?

530

---

What is the difference between clustered and non-clustered index in sql?

519

---

What is the difference between delete, truncate and drop command?

547

---