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
- 10446 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / aravinda
package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions.
Modularity, easy to design applications, information hiding,
added functionality and best performance.
we can declare global variables in packages which are valid
across application.
without invalidating the package we can modify the package body.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How do sql databases work?
What is difference between pls_integer and integer?
What is interval partition?
Is sql pronounced sequel or sql?
What are the events on which a database trigger can be based?
What is the difference between pl and sql?
How do I start pl sql?
What is sql lookup?
What is normalization in sql?
What is pivot query?
Is sql developer case sensitive?
What are the syntax and use of the coalesce function?
What is a record in a database?
How do I run a pl sql program?
How do we use distinct statement? What is its use?
