Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
tell my any difficult situtation you solved in your experience in your company?
Tell me where we find the status of order information?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
where to define interorganization transaction charges and what are the different options?
What are the Standard Reports and Forms in HRMS?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What do you understand by a set of books?
How is choreography different from orchestration?
List the types of flexfield?
In hierarchical structure of a database? we have write query from where we should start?
What is a value set? List its various types.
How many schemas we have? how many you have used?
In support project one ticket alloted which steps follows manualy tell me ?
what is pay run id ?
Explain oracle apps architecture.
