Answer / priyanka samal

Forward declaration means:first you declare the function
what function u want to use in package.atlast doing all the
details of procedure whatever u taken in package
specification.then u define all the details or body part of
function.

2:if u not define function first,there is aerror u have
faced.when u passed this function in procedure
defination,there is a error u faced in compilation.The
procedure can't recognized that function.

Answer / swapna

Forward Declaration means.. If you are defining a package
body having two procedures , If u want to use second
procedure in the defination of first procedure.

You have to declare the second package with its arguments
(if have) before using in the defination of first
procedure.its labled as forward declaration.

Answer / papia

You must declare the identifier before referencing them.
It consists of the subprogram specification teminated by a
semicolon.

Answer / raghavendra

declaration first defination later is nothing but a forward
declaration

How can we schedule the procedure to run automatically ?

3 Answers  

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

Which one is faster ienumerable or iqueryable?

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

How can you save or place your msg in a table?

0 Answers  

---

What is parallel hint?

0 Answers  

---

What is sqlerrd?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

Explain aggregate functions are available there in sql?

0 Answers  

---