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.

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

---

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---

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.

2 Answers  

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

Can you explain the difference between architecture followed in 10g & 11g?

0 Answers  

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

link between po and ap modules

5 Answers   ERP Solutions,

---