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 |
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
How can u call a standard interface program from sql or pl/sql code?
what is latest version in reports
Can We Create a Synonym On Trigger?
what is Flex mode and Confine mode?
The report output is 10 pages then how many times between pages report trigger will fire?
In interface how u find errors and how to solve. How to fix it?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
what is meant by Drill Down in Discoverer report? why it will be use?
What is Value Set?
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION