Tags
Stored Object
Stored objects (packages, types, functions, procedures and triggers).
General
General topics.
Modeling
Database modeling and design.
Control
Control structures: cursors, conditionals and flow control.
SQL
Integration of SQL (DQL, DML and TCL) in stored objects.
Pattern
Common programming patterns.
PinkDB
The Pink Database paradigm (PinkDB) is an application architecture for database-centric applications.
Naming PL/SQL
Naming conventions for PL/SQL identifiers.
Naming SQL
Naming conventions for SQL objects and identifiers.
Variable
Variables and data types.
Observability
Logging, tracing, debugging and monitoring.
Exception
Exception handling.
Performance
Efficient use of resources.
Function Usage
Usage of provided functions.
Hint
Optimizer Hint usages.
Dynamic SQL
Dynamic SQL.