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 sharding in sql?

0 Answers  

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What are the data types allowed in a table?

3 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is a pragma statement?

0 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---

How do you update a table in sql?

0 Answers  

---

What is a unique key?

0 Answers  

---

How delete all data from table in sql?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---