Answer Posted / kiran kumar
---- is a named pl/sql block to perform a specific task.
---- A procedure may have DML statements.
---- It may or may not return a value.
---- Procedure can return more than one value.
Example for procedure
1)To accept the year as a parameter and list emp belong to
the year?
Create or replace
Procedure empy(y number) is
Cursor emp_cursor is
Select * from emp where to_char(hiredate,?yyyy?)=?y?;
Emp_record emp%rowtype;
Begin
For emp_record in emp_cursor loop
Print (emp_record.empno);
Print (emp_record.ename);
Print (emp_record.sal);
End loop;
End;
Output :
var empx number;
Begin
:empx := ?1234?;
End;
Exec empy(:empx);
Print empy;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sca and how is it useful?
what is pay run id ?
Do you know what is applysys in oracle application database schema, what is apps?
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
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is oracle soa suite and what are its different components?
Do you know what are user profiles in apps. Any examples you can give?
List the various types of value set.
What do you understand by concurrent programs?
What does appl_top directory contain?
where to define interorganization transaction charges and what are the different options?
What are file in oracle.
Do you know where we can check the status of po?
In hierarchical structure of a database? we have write query from where we should start?