what is the difference between procedure and function

Answers were Sorted based on User's Feedback



what is the difference between procedure and function..

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

what is the difference between procedure and function..

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

what is the difference between procedure and function..

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

Post New Answer

More Oracle Apps Technical Interview Questions

can we use anchor propery in XML reports?if yes?explain?

2 Answers   Oracle,


In sequence i want to 11 and 15th values how we will write?

0 Answers  


what is the difference between procedure and function

3 Answers   Wipro,


What is request group

4 Answers   Accenture,


what is meant by Table space?

2 Answers  






what is MRC? Why it is needed?

4 Answers   Convergys,


why we can use synonym?

6 Answers  


In oracle application how do you debug or trace errors?

0 Answers  


how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,


what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,


What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,


What are the requests groups?

3 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)