|
Answer» Following are the features of PL/SQL: - PL/SQL provides the feature of decision making, looping, and BRANCHING by making use of its procedural nature.
- Multiple queries can be processed in one block by making use of a single command using PL/SQL.
- The PL/SQL code can be reused by applications as they can be grouped and stored in databases as PL/SQL units like FUNCTIONS, procedures, packages, triggers, and types.
- PL/SQL supports exception handling by making use of an exception handling block.
- Along with exception handling, PL/SQL also supports error CHECKING and validation of data before data manipulation.
- Applications developed using PL/SQL are PORTABLE across computer hardware or operating system where there is an ORACLE engine.
|
