Packages are bunch of procedures and functions instead of granting one by

why we go for package? what are the advantages of using
instead of seperate procuderes or functions

Question Posted / dhiraj

Answer Posted / dhiraj

Packages are bunch of procedures and functions instead of
granting one by one procedure and function DBA can grant
packge to user.

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Is sql easier than java?

1004

What are sql constraints?

1172

What does a pl/sql package consist of?

971

Can we insert data into materialized view?

940

What is lexical units in pl sql?

1140

how to calculate the difference between two dates? : Sql dba

1055

How to use transactions efficiently : transact sql

1050

Does sql view stored data?

949

What is the use of sql trace?

947

what are all the different normalizations? : Sql dba

1030

How to check if a column is nullable before setting to nullable?

1120

What is a data definition language?

1100

When you have to use a default "rollback to" savepoint of plvlog?

1186

What is a table?

1007

Can we rollback truncate?

996