Answer / raji_4u

stored procedure can not return a value using the return
statement. though a stored procedure can contain a return
statement but should not return a value.simply "return".

in a manner,stored procedure can return values to the
calling block through the OUT,INOUT parameter modes.

Answer / neel armstrong

Stored procedure will return the values based on the OUT
parameters

Answer / sravanthi280

A procedure need not return a value always.

Answer / adarsh katiyar

Iin a manner,stored procedure can return values to the block when found any error in the block. Then block exit out and stop all transction immediate.

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

How many types of keys are there in sql?

0 Answers  

---

Explain aggregate functions are available there in sql?

0 Answers  

---

How do you create a unique index?

0 Answers  

---

---

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---

What is java sql driver?

0 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

What is trigger in sql and its types?

0 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---