Answer Posted / Rashmi Banival
PL/SQL packages offer several benefits. They provide a modular structure, making it easier to manage and reuse code. Packages can contain procedures, functions, types, and exceptions, reducing the need for repetitive coding. They improve application performance by reducing compile time and network traffic as they are compiled once and stored in the database. Packages also enhance security as they allow fine-grained access control.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many tables will create when we create table, what are they? : Sql dba
what is collation? : Sql dba
Can we rollback truncate?
define sql insert statement ? : Sql dba
Do we need to rebuild index after truncate?
What is the best sql course?
If a cursor is open, how can we find in a pl/sql block?
what is sql server agent? : Sql dba
Is primary key always clustered index?
what are the advantages of sql ? : Sql dba
Does group by remove duplicates?
how to start mysql server? : Sql dba
what is bcp? When does it used? : Sql dba
Can delete statement be rollbacked?
how to escape special characters in sql statements? : Sql dba