What are the advantages of the packages

Answer Posted / chandrasekar.ramasamy

Package-> Compiles and stores all the procedures and
functions in SGA (System Global Area), so the performance
will be high.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between a web-garden and a web-farm? : Sql dba

556


What is the difference between database trigger and stored procedure?

557


What is AUTH_ID and AUTH_USER in pl/sql ?

1694


What normalization means?

527


What is index example?

558






What is normalization? How many normalization forms are there?

554


What is the difference between a primary key and a clustered index?

526


What are the two types of cursors in pl sql?

542


What is keys and its types?

543


Why we use triggers in mysql?

560


What is cursor explain with example?

555


Define join and name different types of joins?

520


What is rename in sql?

554


How exception is different from error?

544


What are the types of dbms?

546