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 do I copy a table in sql?

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

---

What is the file extension for sql database?

0 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---