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 to make a parameter optional in the query?
WHAT IS REFCURSOR IN ORACLE ?
how to create requst set in oracle apps and how to send muliple requests at a time,
Can u define exceptions twice in same block?
wht r the basetables of customer interface?
Can you have two stored functions with in the same name?
how many groups we can create for query?
How to move the one file from one instance to another instance? And your scripts also?
we have 4 managers if one person logon the system automatically displays his siganature and name how?
What are triggers?
what is the data type of lexical parameter?
is UOM maintained at master level or organization level or both?