Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Store procedure will return a value?

Answers were Sorted based on User's Feedback



Store procedure will return a value?..

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.

Is This Answer Correct ?    20 Yes 0 No

Store procedure will return a value?..

Answer / neel armstrong

Stored procedure will return the values based on the OUT
parameters

Is This Answer Correct ?    12 Yes 1 No

Store procedure will return a value?..

Answer / sravanthi280

A procedure need not return a value always.

Is This Answer Correct ?    4 Yes 0 No

Store procedure will return a value?..

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

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  






Categories