Interested to Buy Any Domain ? << Click Here >> for more details...
why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 10314 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions are
1.reduces number of acces to database.since, When you call
a packaged PL/SQL construct for the first time, the whole
package is loaded into memory. Thus, later calls to
constructs in the same package require no disk input/output
(I/O).
2.we can have overloading,public and private,encapsulation
features (like java) in package
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are all the different normalizations?
How to use sql statements in pl/sql?
How to prepare for oracle pl sql certification?
How many types of triggers are there in pl sql?
How many types of triggers exist in pl/sql?
What is the size of partition table?
How is sql used in oracle?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is the difference between the conventional and direct path loads? : aql loader
What are all different types of collation sensitivity?
What is minus?
how to concatenate two character strings? : Sql dba
What are pl sql data types?
What is snowflake sql?
Why do we create views in sql?
