why we go for package? what are the advantages of using
instead of seperate procuderes or functions
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
What is the difference between partitioning and sharding?
How do I run a query in pl sql developer?
Can we enter data in a table in design view?
how to drop an existing view in mysql? : Sql dba
What is update query?
what are the types of join and explain each? : Sql dba
what is single byte over head in oracle..?
What are literals in sql server?
What mean sql?
Is sql pronounced sequel or sql?
What is the size of partition table?
When sql appeared?
What is a rank in sql?
What is full join in sql?
Is primary key clustered or nonclustered?