what is the difference between procedure and function
- 3 Answers
- 6955 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 |
What is the Exception. Types of exception, Difference between those. And example
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
What are profile options?
wht is the use of Xml reports over reports6i?
define steps of assigning items to an organization.
What do you understand by a set of books?
What are ad-hoc reports?
how to set org context?
Difference between Bind and Lexical parameters?
in one report using two layout models.if yes how to do
what are the steps to develop a new report?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
Oracle Apps Technical 
