Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of the packages
- 6 Answers
- 12328 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
* 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 ? | 11 Yes | 0 No |
Answer / akki julakanti
Advantages of Packages:
1.Encapsulation
2.Overloading
3.Better Performance
4.Information hiding
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / chandrasekar.ramasamy
Package-> Compiles and stores all the procedures and
functions in SGA (System Global Area), so the performance
will be high.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / manoj kaushik
Advantages of Packages --Modularity,Easier Application
Design,Information Hiding,Added Functionality,Better
Performance.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / senthilkumar
Package is a group of related database objects like
functions ,procedures and other packages construct together
as a unit in the database.
Advantages:
Modularity
Better Performance(when we are executing any
subprogram in the package, it will be loaded in to the
memory, so performance of the package will be very high)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gireesh.p.v
package is a collection of procedures&functions.
we can use package by simply calling it
| Is This Answer Correct ? | 0 Yes | 2 No |
what is a database lock ? : Sql dba
How to add, remove, modify users using sql?
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
How can I make sql query run faster?
Is left join inner or outer?
Is primary key a clustered index?
How do you exit in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do I restart sql?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
Can we join same table in sql?
-
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)
