What is procedure?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nidhi
Procedure consist of set of the PL/SQL statments that are
grouped togather as a unit to solve a specific problem or
perform set of related tasks.
-->May or may not return the value.
-->can not use in teh sql queries because returns more than
one value.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandrasekhar
procedure is subprogram in pl/sql that contains a set of
SQL and PL/SQL statements.Subprograms once we executed can
be used in any no.of applications
Is This Answer Correct ? | 0 Yes | 0 No |
What does appl_top directory contain?
Difference between triggers and procedures?
In which directory your flatfile is given?if u connected different instance where it is find?
what are version control tools used in oracle apps?
when will formula,place holder and summary columns fire in reports?
Tell me some thing about SQL-LOADER.
In sequence i want to 11 and 15th values how we will write?
What is responsibility?
Can u give the Documentation of Custom.pll in oracle apps
what is pay run id ?
which parameters passed in report in oracle developer how to pass
WHAT IS USE OF APPS API?