what is the difference between procedure and function
- 3 Answers
- 6912 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 |
How to develop XML report without rdf?
If there is any issue then whom do you report.(this is imp question for every interview)
What repots or concurrent program run to transfer data from Inventory to GL.
what are the different types of triggers in reports
why we can use synonym?
AOL?
where we can check the status of po.
What is FORWARD DECLARATION in Packages?
6 Answers British Telecom BT, HCL, Tech Mahindra,
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
what is the purpose of standard cost update?
in ap_terms table what data will be stored
Can functions be overloaded ?
Oracle Apps Technical 
