what is the difference between procedure and function
- 4 Answers
- 6075 Views
- I also Faced
- E-Mail Answers
Answer Posted / allabakash
function and procedure both are stored procedures
function contains return clause,where as procedure does not contain return clause
function must return a value, where as procedure may or may not return a value
function can execute as a select statement, where as procedure can execute in anonymous block
we can call function in if statement, we cannot call procedure in if statement
we can call function as a part of expression,where as procedure as a statement
we can pass function as a parameter,where as we cannot pass procedure as a parameter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Do you know what is applysys in oracle application database schema, what is apps?
How can you achieve loose coupling in soa framework?
testing tools?
what are the balancing segments in AR?
In sequence i want to 11 and 15th values how we will write?
Tell me how to debug the report?
Tell me how to find the custom directory in front end?
What do you understand by soa?
List the various types of value set.
List the types of flexfield?
What are the Standard Reports and Forms in HRMS?
In oracle application how do you debug or trace errors?
Can you define an erp system?
can we use look up type instead of a pofile option?or valueset?is it possible how?
