Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 5 Answers
- 10527 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 |
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
what are the default arguments for pl/sql program?
when will formula,place holder and summary columns fire in reports?
PL/SQL stored procedure parameters?
Can u define exceptions twice in same block?
Tell me some thing about SQL-LOADER.
can we pass bind variablein lexical parameter?
what are the different types of parameters avialable in reports?
How will u register concurrent request ?
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
how i can create temporary table?
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
Oracle Apps Technical 
