Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mk
Function:-
A function is a predefined action which can consumed so that
retrieve the information from table in various scenario .
Procedure :-
procedure are SQl and PL/SQL code compile and stored in the
database.
Difference
Procedure
It may or may Not return a value
It can return multiple value also
It has both Input & output parameter
Doesn’t uses return statement for returning a value
Output Parameter will be specify using Output Clause
This allow select as well as DML operation
It support Transaction mgmt and error-handling using TRY and
Catch Block
They can call another procedure and function for Execution
Function
Function
It Must return a value
It can return only single value
It has both Input parameter
Uses return statement for returning a value
Output Parameter will be specify using Return Clause
This allow select as statement
Doesn’t support Transaction mgmt and error-handling using
TRY and Catch Block
They can call only another function for Execution
When will use :-
We will use procedure to perform complex business Logic as
well as we use function while performing simple
mathematical calculation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the original export and import utilities?
What are nested tables?
How to run the anonymous block again?
Does oracle database need java?
master table and child table performances and comparisons in Oracle ?
What are the tools for Oracle ?
What's dateware house and what's clustor with practicle example
What do you mean by a tablespace?
Can group functions be used in the order by clause in oracle?
How to do clean up if create database failed?
What is redo log?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to test null values?
How to download oracle database 10g xe?
How do I know if oracle client is installed on windows?
