What is function?
Answers were Sorted based on User's Feedback
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;
| Is This Answer Correct ? | 5 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
wht is the use of Xml reports over reports6i?
what is meant by lexical parameter
What is MO operating units. Why it need to to set this and where .
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
Types of cursors?
How can u find custom top? where its located? How to find custom top in front end?
Oder of firing triggers in form
Define multi org structure with example(take any businees).
In Per_all_people_f table what is the significance of '_f ' ?
what is fiscalcalendar?
why do we go for oracle apps technical other than sap and other packages?
IN WHICH MODULE THE LEGAL ENTITY COMES?