Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of the packages
- 6 Answers
- 11891 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 |
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are the pre requisites?
what are the properties and different types of sub-queries? : Sql dba
Which join condition can be specified using on clause?
How many types of sql are there?
Explain the update statement in sql
if a table is getting updated what happens if a function is called from sql query?
Write a query to find second highest salary of an employee.
What is indexing in sql and its types?
What are sql triggers used for?
Are sql connections encrypted?
Can we use views in stored procedure?
-
Oracle (3259) - 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)
