Answer / santhaebenezar

function will return a value where as
procedure may or maynot return a value

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

Answer / rambhupal reddy

function can use sql queries
procedure are not used in sql queries

Answer / parvathy

Procedure is written in natural language........
whereas function is a block of codes......

Answer / karthick.r

procedure may or may not return values but function should
return values

what is instead of trigger. what is the use of that?

3 Answers  

Is SOB is attached with Business grp ?

2 Answers   Convergys,

what is the difference between procedure and function

4 Answers  

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

List the various types of value set.

0 Answers  

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  

What is Place holder Columns?

3 Answers  

Can u define exceptions twice in same block?

3 Answers  

After deploying like forms,reports into server how we connect this forms,reports to web?

1 Answers   IBM,

List the types of flexfield?

0 Answers  

what are the different types of triggers in reports

2 Answers   Oracle,