Answer Posted / senthilkumar
Package is a group of related database objects like
functions ,procedures and other packages construct together
as a unit in the database.
Advantages:
Modularity
Better Performance(when we are executing any
subprogram in the package, it will be loaded in to the
memory, so performance of the package will be very high)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by pl/sql packages?
How do you use join?
What is the difference between partition and index?
How to sort the rows in sql.
How to avoid using cursors?
Why is theta join required?
Which join is default?
What are the most important ddl statements in sql?
What is sqlservr exe?
What are properties of the transaction?
What is right join sql?
What is left join in sql?
Can ddl statements be used in pl/sql?
What is mutating error in pl sql?
What are the built in functions of sql?