Answer Posted / 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 |
Post New Answer View All Answers
Define union, minus, union all, intersect ?
Can you join a table to itself?
Why do we go for stored procedures?
Can a foreign key have a different name?
Explain table and field in sql?
How to read/write files from pl/sql?
what are the different functions in sorting an array? : Sql dba
What are different types of statements supported by sql?
What is sql in java?
how mysql optimizes distinct? : Sql dba
How do you optimize a query?
What is a call statement? Explain with an example.
What is the difference between nested table and varray?
How to take user input in pl sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba