why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 9041 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 the largest value that can be stored in a byte data field?
What are joins in sql?
What do you understand by exception handling in pl/sql?
how to get help information from the server? : Sql dba
Which is better varchar or nvarchar?
What does plv msg allows you to do?
What is substitution variable?
How to load data with sql*loader?
what is csv? : Sql dba
How do you rename a table in sql?
How to process query result in pl/sql?
What operators deal with null?
What are the triggers associated with image items?
What are the two parts of design view?
How can I get the number of records affected by a stored procedure?
