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.

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

What is a rank in sql?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

What are the types of operators available in sql?

0 Answers  

---

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

Why is pl sql needed?

0 Answers  

---

how to select unique records from a table? : Sql dba

0 Answers  

---

Can function return multiple values in sql?

0 Answers  

---

what is the sql query to display current date? : Sql dba

0 Answers  

---

Explain unique key in sql.

0 Answers  

---