Design Considerations for PL/SQL Code
- Standardizing Constants and Exceptions
- Local Subprograms
- Definer’s Rights Vs Invoker Rights
- Autonomous Transactions
- Returning Clause
- Bulk Binding
- Bulk Collect
- FORALL, BULK COLLECT INTO with RETURNNG Clause
- Using NOCOPY Hint
- PARALLEL_ENABLE Hint