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

how to calculate expressions with sql statements? : Sql dba

1023

---

What is rename in sql?

954

---

How do you concatenate in sql?

1013

---

what are all the different normalizations? : Sql dba

1015

---

What is normalisation and its types?

988

---

What are the disadvantages of not performing database normalization?

1144

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1180

---

What is the sql case statement?

978

---

how to enter binary numbers in sql statements? : Sql dba

952

---

what is cursor. write example of it. What are the attributes of cursor.

1365

---

Does truncate free space?

989

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1027

---

How would you reference column values before and after you have inserted and deleted triggers?

1048

---

Can we use threading in pl/sql?

1020

---

What are different types of triggers?

1084

---