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 is profile and what is level of profile option and it's hierarchy
What is the difference between base table and multi-org table?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?
How many typres of Purchase order and what are those.
How many parameters we can pass through pl/sql program in Oracle apps
Steps for DFF registration
In custom.pll what are the events we can Not write.
Can you have two stored functions with in the same name?
What are the files you have used in the part of Conversion and Interfaces?
what is meant by boilerplates?
After deploying like forms,reports into server how we connect this forms,reports to web?