1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Store procedure will return a value?

Question Posted / umesh koodali

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

Can a foreign key have a different name?

0 Answers  

how to get help information from the server? : Sql dba

0 Answers  

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,




What are analytic functions in sql?

0 Answers  

What is a record in a database?

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

What is sql server and ase?

0 Answers  

What is Highwatermark?

3 Answers   Thermotech,

What is trigger and types?

0 Answers  

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories