Interested to Buy Any Domain ? << Click Here >> for more details...
Store procedure will return a value?
- 4 Answers
- 11273 Views
- eMids, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / neel armstrong
Stored procedure will return the values based on the OUT
parameters
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sravanthi280
A procedure need not return a value always.
| Is This Answer Correct ? | 4 Yes | 0 No |
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 |
How to select unique records from a table?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
What is the example of procedure?
What is an ndf file?
What are the usage of SAVEPOINTS?
What are sql*plus environment variables?
What is %type in pl sql?
What are two virtual tables available during database trigger execution ?
What is scalar function?
what is the difference between primary key and unique key? : Sql dba
What are the string functions in sql?
Why functions are used in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
