Answer / mukesh rathi

Package is a named anonymus block.
It is collection of varible, procedure,function.
There is need of package specification and body and there
name should be same for creating package.
We can also declare global,local procedure function within
the package.
Due to the use of package the performace improved because
it directly interact with the memory location avilable to
the package.

Answer / kiran kumar

---- Group logically related pl/sql types, items and
subprograms.
1) package specification
2) package body
Advantages of a package:

? Modularity
? Easier Application Design
? Information Hiding
? Overloading

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---

how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

what are the sql attributes?

2 Answers  

---

how many sections are there in report?

1 Answers  

---

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

3 Answers   Wipro,

---

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

1 Answers   TCS,

---

In oracle application how do you debug or trace errors?

0 Answers  

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

how to set org context?

3 Answers  

---

how to customize the report,please tell me customization steps

5 Answers   Accenture,

---

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,

---