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
Can we use ddl statements in stored procedure?
What is varray in pl sql?
how to select first 5 records from a table? : Sql dba
What is a unique key?
Can we use two order by clause in query?
Which table is left in left join?
How can you load microsoft excel data into oracle? : aql loader
What are the two types of exceptions.
What is the difference between count 1 and count (*) in a sql query?
What is equi join in sql?
What is nested table in pl sql?
Are subqueries better than joins?
What is trigger price?
Can we insert data into view?
What is query execution plan in sql?