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 |
what is latest version in reports
why r u move in the cus_top only why not move another top
Can We Create a Synonym On Trigger?
What are the files we submit while your program move to testing instance?
What is responsibility?
LOCKS?
I want to print output in portrait style?where i have to change the settings?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
wht is the use of Xml reports over reports6i?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
please explain open interface import
What is sca and how is it useful?