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

What are ad-hoc reports?

1 Answers  

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

What are the Standard Reports and Forms in HRMS?

0 Answers  

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---

---

When loading data from staging table to interface table , how to reload the invalid record once again ?

6 Answers   Accenture,

---

what are the sql attributes?

2 Answers  

---

in one report using two layout models.if yes how to do

3 Answers   Wipro,

---

In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??

1 Answers  

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

0 Answers  

---

What is procedure?

3 Answers   IBM,

---

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

---