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

what is flexfield qualifier?

3 Answers  

---

What is cursor?

3 Answers  

---

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,

---

how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  

---

What is oracle soa suite and what are its different components?

0 Answers  

---

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 ?

7 Answers   Satyam,

---

I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

What is instead of trigger in where we will use?

0 Answers  

---

What is workflow?Explain with a example?

2 Answers   Oracle,

---

what is the prerequisite for defining unit of measure?

1 Answers   Scan Steel, TCS,

---

What are the Major differences between appcore.pll and appcore2.pll

5 Answers   Infosys, Sierra Atlantica,

---