what is the difference between procedure and function
Answers were Sorted based on User's Feedback
Answer / mry
procedure is for specific task and can return one or more
values to the caller
where as function is used for computing a value and it must
return a single value to the caller
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tamil selvan.s
Main diff between procedure and function is
function can be used in select statement but
we cannot use procedure
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ramesh babu maldakal
1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions
| Is This Answer Correct ? | 2 Yes | 1 No |
What is sca and how is it useful?
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
LOCKS?
What is Value Set?
what is trace file? what is the use of that?
What do you understand by soa?
what is user exit and wat program do we write in user exit?
what are the different calculation columns available in reports?
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
What do you understand by a set of books?
q)what are the validations in sql*loader
what are the mandatory parameters in suppler Conversion?