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
- 10294 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 different types of statements supported by sql?
What is the usage of nvl function?
What is rownum and rowid?
What are the different types of a subquery?
What is sql injection owasp?
What is oracle pl sql developer?
When are we going to use truncate and delete?
How to avoid duplicate records in a query?
How can a function retun more than one value in oracle with proper example?
Is sql a dbms?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
How do I view stored procedures?
Enlist the characteristics of pl/sql?
what are the t string functions available in tsql? : Transact sql
What is the usage of the distinct keyword?
