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 does a pl/sql package consist of?

511


Write a sql query to get the third highest salary of an employee from employee_table?

625


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

507


How do you write an inner join query?

504


How many parts of a pl sql block are optional?

513






What is data manipulation language?

688


Is sql better than excel?

512


What is difference between cursor and trigger?

549


What is the meaning of disabling a trigger?

643


What is a sql driver?

521


What are transaction and its controls?

554


Write the alter statement to enable all the triggers on the t.students table.

658


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

613


What is the difference between microsoft access and sql server?

525


how many tables will create when we create table, what are they? : Sql dba

535