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

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

What is responsibility and how u attach

5 Answers   Accenture,

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

After completing Report customization process.suppose we have 10 report parameter in report so, that we re-register that parameter in concurrent program?

3 Answers   IBM,

how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,

Difference between triggers and procedures?

2 Answers  

what is the data type of lexical parameter?

5 Answers   Wipro,

What is the Exception. Types of exception, Difference between those. And example

2 Answers   IBM,

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  

what do you mean by value sets

8 Answers   Convergys,