Answer Posted / raj dhar
Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.
Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.
Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.
etc.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to retrieve values from data fields in record variables?
Explain a synonym?
What are the differences between date and timestamp in oracle?
What is oracle sid?
Does oracle partitioning improve performance?
what is the difference between restoring and recovering?
How to bring a tablespace offline?
What is the difference between view and materialized view in Oracle?
How to use like conditions in oracle?
How do I manually create a database in oracle?
List out the difference between commit, rollback, and savepoint?
What is system global area (sga) in oracle?
 How to use an oracle sequence generator in a mapping?
What is java oracle used for?
What happens if you lost a data file?