Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of package?
- 7 Answers
- 40371 Views
- iFlex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 55 Yes | 3 No |
Answer / arup ratann banerjee
The advantage of package is :---
1) Encapsulation
2) Security
3) Performance gaining
4) Overloading and polymorphism
| Is This Answer Correct ? | 47 Yes | 8 No |
Answer / suresh somayajula
Advantages of packages :
1. easier application and design
2. Information hiding
3. moularity and maintainability.
| Is This Answer Correct ? | 20 Yes | 4 No |
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.
| Is This Answer Correct ? | 23 Yes | 8 No |
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.
| Is This Answer Correct ? | 17 Yes | 4 No |
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.
| Is This Answer Correct ? | 18 Yes | 5 No |
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
what is a unique key ? : Sql dba
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
Are sql database names case sensitive?
What does the sign mean in sql?
what is online transaction processing (oltp)? : Sql dba
Which constraints we can use while creating database in sql?
How does a trigger work?
What are the types of sql commands?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
Explain unique key in sql.
How can triggers be used for the table auditing?
Difference between aggregate function and analytical function?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
