Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of the packages
- 6 Answers
- 12181 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 |
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
How will you select unique values from a list of records?
What are tuples in sql?
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
What are pl/sql cursors?
What are the benefits of triggers?
What is microsoft t sql?
What sql database should I use?
How can I pass the inner procedure value to outer procedure ?
What is cursor in pl sql with examples?
What does subquery mean in sql?
Which are the different types of indexes in sql?
-
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)
