what is difference between procedure and function
- 5 Answers
- 8279 Views
- E Logic, I also Faced
- E-Mail Answers
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 files you have used in the part of Conversion and Interfaces?
What is template?
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
How can we import the data into a database using sql * loader?
how many layout sections are tehre in layout editor?
what are the prerequisites for costing transactions?
why do we validate the records while developing interface?
Do you know where we can check the status of po?
what is the difference between procedure and function
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
can we get profile values in report without using user exists is it possible how?
how to set org context?
Oracle Apps Technical 
