why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 8992 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 is schema in sql example?
how can we know the count/number of elements of an array? : Sql dba
What is the file extension for sql database?
How to find 3rd highest salary of an employee from the employee table in sql?
How to test for null values?
What is sorting in sql?
What are some emotional triggers?
What is the full form of sql?
Does inner join remove duplicates?
Why we use triggers in mysql?
What is mutating table error?
What does trigger mean in psychology?
Why having clause is used in sql?
Is oracle sql free?
What are inner outer left and right joins in sql?
