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 sql server and ase?

711


Write a sql select query that only returns each name only once from a table?

757


Write a sql query to convert all character to uppercase after hypen.

1165


What is a dirty read sql?

712


What is the use of function in sql?

727






name 3 ways to get an accurate count of the number of records in a table? : Sql dba

786


can a stored procedure call itself or recursive stored procedure? : Sql dba

751


What is the purpose of the partition table?

751


What is cursor and its types?

715


What is mutating trigger?

767


What do you understand by pl/sql cursors?

739


What is a sql*loader control file?

788


what is user defined functions? : Sql dba

743


What is view explain with example?

685


What are the topics in pl sql?

698