Answer / mry

procedure is for specific task and can return one or more
values to the caller
where as function is used for computing a value and it must
return a single value to the caller

Answer / tamil selvan.s

Main diff between procedure and function is
function can be used in select statement but
we cannot use procedure

Answer / ramesh babu maldakal

1 Function returns the values but not procedure
2 We can call the functions in select statement but not
procedures
3 In procedures we can perform the DML operations but not
in Functions

How to migrate .rdf file from dev instance to test instance?

3 Answers   Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

What is procedure?

3 Answers   IBM,

---

What is SRW Package? (Sql Report Writer)

1 Answers  

---

what is meant by bind parameter?

2 Answers   Satyam,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

6 Answers   Tech Mahindra,

---

how to call report from oracle oracle apps11i?

3 Answers   Genpact,

---

in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,

---

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

What is cursor?

3 Answers  

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---

what is the difference between character mode,bitmap mode

2 Answers   IBM, Sierra Atlantica,

---