difference b/w procedures&functions
Answers were Sorted based on User's Feedback
Answer / abhi choudary
procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / raghu
procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written
Is This Answer Correct ? | 3 Yes | 1 No |
How many phases of implementation and what are those.
what is Flex mode and Confine mode?
What is MO operating units. Why it need to to set this and where .
What is secuirity's in R12 features.
What is Pragma Autonomous transaction. It's Real time Example
what is instead of trigger. what is the use of that?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is the difference between buyer&employee in PO module?
Can we run a package with out specification?If yes how?
Explain oracle apps architecture.
If there is any issue then whom do you report.(this is imp question for every interview)
what is meant by boilerplates?