Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function
- 3 Answers
- 8453 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
tell me the scenarios of the independent in reports
What is menu.
what is organization id
q)what are the validations in sql*loader
In interface how u find errors and how to solve. How to fix it?
what is the use of anchors?
How You Will display the key flexifields in your report
which API to return the parameters & valuesets etc
diff between key and descriptive flexfield.
Tell me how to find the custom directory in front end?
In oracle application how do you debug or trace errors?
difference b/w procedures&functions
Oracle Apps Technical 
