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
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Do you know what are user profiles in apps. Any examples you can give?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
How can we import the data into a database using sql * loader?
What is a value set? List its various types.
What is a flexfield? List out its types.
What is oracle soa suite and what are its different components?
What are the Standard Reports and Forms in HRMS?
List the types of flexfield?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
tell my any difficult situtation you solved in your experience in your company?
What is oracle soa suite?
Explain what are the tables of auto invoice?
how to print multi lay outs,muti currency,muti language in xml publisher
can we use look up type instead of a pofile option?or valueset?is it possible how?
