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
If a cursor is open, how can we find in a pl/sql block?
What is indexing in sql and its types?
List the ways to get the count of records in a table?
What is file based approach?
What is the use of double ampersand (&&) in sql queries? Give an example
What is an alias command?
Where is sql database stored?
How to use distinct and count in sql query? Explain
what are different types of keys in sql?
Do we need commit after truncate?
Can we create clustered index without primary key?
Why are aggregate functions called so?
Which one is better sql or oracle?
What are schema-level triggers?
What is date functions?