what is difference between procedure and function
Answers were Sorted based on User's Feedback
Answer / santhaebenezar
function will return a value where as
procedure may or maynot return a value
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / venky
Function can be use in SQL queries
Procedure can't be used in SQL queries
Function call by an Expression
Procedure call by Statement
The Main diff is DML
Through procedures we can insert,update,delete data from
Table
Through Functions we can't
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / rambhupal reddy
function can use sql queries
procedure are not used in sql queries
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / parvathy
Procedure is written in natural language........
whereas function is a block of codes......
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / karthick.r
procedure may or may not return values but function should
return values
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the Major differences between appcore.pll and appcore2.pll
5 Answers Infosys, Sierra Atlantica,
is it possible to run the interface without using oracle apps?
what are the difference between oracle discoverer and report6i
name all status attributes.
what is mutating table and mutating error and how to solve that?
Define MultiOrg Structure
what are the pl/sql tables
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
while doing the process of conversion if got any data error out what is the next step to reprocess
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?