Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 5 Answers
- 10118 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 |
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
What is the package?
what is meant by anchoring?
what is mean by confine mode and flexi mode?
how many sections are there in report?
how to make a parameter optional in the query?
Stored procedure?
how many layout sections are tehre in layout editor?
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
what is the use of format trigger?a
Difference between Bind and Lexical parameters?
what are the functions you are used in utl_file at the time of transferring the data?
Oracle Apps Technical 
