why we go for package? what are the advantages of using
instead of seperate procuderes or functions
- 3 Answers
- 9564 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
What is scalar function in sql?
What is online transaction processing (oltp)?
Why we use join in sql?
What is the difference between execution of triggers and stored procedures?
what is clause? : Sql dba
What is the difference between local variables and global variables?
What is t-sql? : Transact sql
what tools available for managing mysql server? : Sql dba
What are all the common sql functions?
Are views faster than queries?
Why select is used in sql?
What is a unique key and primary key and foreign key?
What is rank () in sql?
Why coalesce is used in sql?
What are records give examples?
