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 is an inconsistent dependency?
Does a user_objects view have an entry for a trigger?
How does one load ebcdic data? : aql loader
Explain what is sql?
Why is pl sql needed?
Is primary key a clustered index?
What is substitution variable in pl sql?
What are analytical functions in sql?
How do you drop a trigger?
How do I tune a sql query?
What is cold data?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are the different types of a subquery?
How can use stored procedures in sql?
Can we create a trigger on view?