Answer / kiran kumar

---- is a named pl/sql block to perform a specific task, is
mainly used for calculation purpose.
---- A function is called as part of an exception.
---- Every function should return a value
Example for function
Create or replace
Function get_sal(p_id in emp.emp_no% type)
Return number
Is
v_sal emp.sal%type :=0;
Begin
Select salary into v_salary

From emp

Where emp_no = p_id;
Return v_salary
End get_sal;
End;

Output :
var g_sal number;
Exec :g_sal := get_sal(99);
Print g_salary;

Answer / dipa paul

To tell one sentence, function is -- which return a value
that value can be boolean,char, number and null.

We can use function in oracle form or report bulider and
stored in database.

what is instead of trigger in where u will use?

2 Answers   TCS,

---

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,

---

what is difference between procedure and function

5 Answers   E Logic,

---

what is repeting frame?

3 Answers   TCS,

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me

2 Answers   Pathway Technologies,

---

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

4 Answers   Infosys, Sierra Atlantica,

---

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,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

---