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 / srinivas

Function returns only one value, whereas procedure returns
multiple values.
Function can be used in SQL queries whereas we can't use
procedures.
I think in procedures values by reference is not possible.

Is This Answer Correct ?    2 Yes 0 No

what is the difference between procedure and function..

Answer / venki_discussions

procedure perform one or more actions it may return or may
not return values if u want to return procedure ill return
multiple values.we can use procedures in oracel apps also

function perform one or more actions and it must return any
value multiple values will not return function.functions
we cant use in oracle apps.we can perform functions on SQL
prompt itslef.

Is This Answer Correct ?    1 Yes 1 No

what is the difference between procedure and function..

Answer / chalam

Function will return only 1 value where as the procedures
will return values or may not be return.

Is This Answer Correct ?    0 Yes 0 No

what is the difference between procedure and function..

Answer / allabakash

function and procedure both are stored procedures
function contains return clause,where as procedure does not contain return clause
function must return a value, where as procedure may or may not return a value
function can execute as a select statement, where as procedure can execute in anonymous block
we can call function in if statement, we cannot call procedure in if statement
we can call function as a part of expression,where as procedure as a statement
we can pass function as a parameter,where as we cannot pass procedure as a parameter.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

please explain open interface import

2 Answers  


in procedure how to return a value

3 Answers  


Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,


where do u specify in org_id?

2 Answers  


Can you differentiate between mediator and osb?

0 Answers  


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,


what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,


HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?

2 Answers   TCS,


why do we validate the records while developing interface?

3 Answers   TCS,


for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  


pls send me out bound code of supplers,site,bankiformation code pls as soon as

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