difference b/w procedures&functions

Answers were Sorted based on User's Feedback



difference b/w procedures&functions..

Answer / abhi choudary

procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use

Is This Answer Correct ?    14 Yes 0 No

difference b/w procedures&functions..

Answer / raghu

procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

How many phases of implementation and what are those.

2 Answers   Accenture,


what is Flex mode and Confine mode?

2 Answers   Rapidigm,


What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,


What is secuirity's in R12 features.

1 Answers   KPIT,


What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,






what is instead of trigger. what is the use of that?

3 Answers  


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  


What is the difference between buyer&employee in PO module?

7 Answers   TCS,


Can we run a package with out specification?If yes how?

4 Answers  


Explain oracle apps architecture.

0 Answers  


If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,


what is meant by boilerplates?

1 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)