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.

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,

---

what is pay run id ?

0 Answers  

---

In one flat file i got headers and lines data how you can write control file now ?

1 Answers   KPMG,

---

LOCKS?

1 Answers  

---

what is flexfield qualifier?

3 Answers  

---

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,

---

can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

what r the objects u have to do in u experiance

1 Answers  

---

what are the default arguments for pl/sql program?

1 Answers  

---

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

How can we import the data into a database using sql * loader?

0 Answers  

---