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 to make a parameter optional in the query?

2 Answers   Wipro,

---

PL/SQL stored procedure parameters?

7 Answers  

---

What is Place holder Columns?

3 Answers  

---

where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  

---

List the various types of value set.

0 Answers  

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

what is meant by bind parameter?

2 Answers   Satyam,

---

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

---