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
- 10136 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 myisam? : Sql dba
Is sql better than access?
Explain the structure of pl/sql in brief.
What are its different types of dbms?
Why do we use triggers?
What is a system versioned table?
What is java sql driver?
How to select unique records from a table?
Explain the significance of the & and && operators in pl sql.
How can triggers be used for the table auditing?
what is auto increment? : Sql dba
How many joins can you have in sql?
What is a natural join?
What is mutating error?
How can a pl sql block be executed?
