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 is the difference between inner and outer join? Explain with example. : Sql dba

1 Answers  

---

What is sp_helptext?

1 Answers  

---

Can we use ddl statements in stored procedure?

1 Answers  

---

Is nosql faster than sql?

1 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

How do I clear the screen in sql plus?

1 Answers  

---

Is left join same as inner join?

1 Answers  

---

How does join work in sql?

1 Answers  

---

What are sql triggers used for?

1 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1 Answers  

---

Explain the difference between sql and mysql.

1 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---