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 r the validation types?

3 Answers  

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---

How do u customize the Reports?

1 Answers  

---

in one report using two layout models.if yes how to do

4 Answers   Covansys,

---

what is organization id

2 Answers   Wipro,

---

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

How to attach the multiple templates in XML Pub Report?

2 Answers   Intelligroup, KPIT,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

Which oracle apps version you are very confident in?

0 Answers  

---

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,

---