Mention what are the benefits of pl/sql packages?
Answer / 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 |
What is a primary key sql?
What is sql analyzer?
what is a sub query?how will you calculate working days in a month using sub query?
Why stored procedure is better than query?
Is hadoop a nosql?
What is rtm in testing?
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
How does left join work in sql?
What does data normalization mean?
What is sql and db2?
find the third highest salary?
how will be date change into string
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)