What are the advantages of the packages

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


Please Help Members By Posting Answers For Below Questions

What is the difference between joins?

728


is mysql query is case sensitive? : Sql dba

769


What is minus?

751


What are triggers and its uses?

783


How to select random rows from a table?

725






Can you load data into multiple tables at once? : aql loader

797


What are pl/sql cursors?

727


What is the primary key?

698


Why do we need a foreign key?

755


Why query optimization is needed?

679


Which is faster view or stored procedure?

688


What are the advantages of indexing?

720


What is autocommit sql?

704


Can we use update in sql function?

770


How to return multiple rows from the stored procedure?

711