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
testing tools?
what is global tempory table?
Explain what are the tables of auto invoice?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
what are the different transaction clauses in AR?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What is oracle soa suite?
Tell me where we find the status of order information?
please send me forms, xml pulisher questions,answers
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
is it possible to run the interface without using oracle apps?
Do you know where we can check the status of po?
q)what are the validations in sql*loader
What do you understand by a set of books?
How can you achieve loose coupling in soa framework?
