why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 9563 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
discuss about myisam key cache. : Sql dba
what are different types of keys in sql?
How many types of functions are there in sql?
Why is a trigger used?
What is the use of sql trace?
how to load data files into tables with 'mysqlimport'? : Sql dba
Do foreign keys improve performance?
Why functions are used in sql?
What is write ahead logging in sql server?
Why join is faster than subquery?
what's the difference between a primary key and a unique key? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
how to concatenate two character strings? : Sql dba
What is nvl?
What are different sql data types?
