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

What is the use of partition by in sql?

0 Answers  

---

How do I view a procedure in sql?

0 Answers  

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

What is the current version of sql?

0 Answers  

---

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

---

What is nvarchar in sql?

0 Answers  

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

explain normalization concept? : Sql dba

0 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---