Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 5 Answers
- 10362 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 requests groups?
What is template?
What are do's and dont's of Interface?
What is workflow?Explain with a example?
what is the diff between custom.pll and form personalization? Tell me one example?
where we can check the status of po.
Can 2 functions have same name & input parameters but differ only by return datatype ?
Give a brief overview on OrderManagement.
what is pay run id ?
What are ad-hoc reports?
Name the different Cursor Attributes.
List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS
Oracle Apps Technical 
