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 are the important table names in purchasing?
What are triggers?
How to register a form and stored procedure in oracle apps
How to find which company will be conducted Oracle appa interview? Plz help me
What do you understand by soa?
Steps for DFF registration
Tell me some errors names and number what u got while developing the reports?
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
What is invoice?
What are the User PARAMETERS in the Reports?
What is SET-OF-BOOKS?
What is Value Set?