Answer / useroracle

Advantages of package:
-----------------------
A. Modularity
- Encapsulate related constructs.

B. Easier Application Design
- Code and compile specification and body separately.

C. Hiding Information
- Only the declarations in the pacakge specification
are visible and accessible to application.
- Private constructs in the package body are hidden
and inaccesible.
- All coding is hidden in the package body.

D. Added Functionality
- Persistency of variables and coursors.

E. Better Performance
- The entire package is loaded into memory when the
package is first referenced.
- There is only one copy in memory for all users.
- The dependency hierarchy is simplified.

F. Overloading
- Multiple subprograms of the same name.

Answer / arup ratann banerjee

The advantage of package is :---
1) Encapsulation
2) Security
3) Performance gaining
4) Overloading and polymorphism

Answer / suresh somayajula

Advantages of packages :

1. easier application and design
2. Information hiding
3. moularity and maintainability.

Answer / roopesh kumar

The main purpose for using a packege is grouping the
related objects like proc., func. etc.

For ex. we can create one package for payroll of HRMS system
that can be used for storing related proc, func. & other DB
objects.

Answer / pranab kumar mishra

1.Saving the rext of the create package statement in two
different sql files facilitates latter modification to the
package.Each package is easily understood & interface
between package are simple,clear& well defined.

2.package promote code reuse through the use of library that
contain stored procedure & function.so redundent coding.

3.Hiding information.

Answer / madhavi

The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.

Answer / priya

Package is a group of similar types of classes, interfaces and sub-packages. .
Packages is used to categorize the classes and interfaces.
Packages provides access protection. Package removes naming collision.

What is normalization in a database?

0 Answers  

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

what is self join and how it works??

2 Answers   Infosys,

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

What are the different operators available in sql?

0 Answers  

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

Why do you partition data?

0 Answers  

what is autonomouse transaction?

3 Answers   Oracle,

write a query to delete similar records in same table

13 Answers   TCS,

Why partition by is used in sql?

0 Answers