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 the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

Sys Admin Module?

1 Answers  

---

we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?

4 Answers  

---

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

2 Answers   IBM,

---

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

Plz anybody send me Technical specification for AP Interface

0 Answers   Satyam,

---

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

---

How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---