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 |
how to enable Zoom function and steps?
What is the interface?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
What repots or concurrent program run to transfer data from Inventory to GL.
Registering parametric report?
what is difference between po_headers_all and po_headers
How does accounting occured in Expense Reporting?
what is difference between procedure and function
How to move the one file from one instance to another instance? And your scripts also?
what is the use of placeholer column?
what is meant by lexical parameter
Can you have two stored functions with in the same name?