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;

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.

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

How to link between inventory and OrderManagement.

1 Answers   Zensar,

---

what is the difference between oracle 8i and 9i?

1 Answers  

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

Challenges faced during upgradation of 11i to R12

1 Answers   Infosys, Satyam,

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---

why we can use synonym?

6 Answers  

---

why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,

---

In a Standard form a DFF is disable?How we can Enable it?

5 Answers   Caritor, TCS,

---

What is workflow?Explain with a example?

2 Answers   Oracle,

---

What are file in oracle.

0 Answers   BirlaSoft, IBM,

---

Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,

---

when will formula,place holder and summary columns fire in reports?

1 Answers   TCS,

---