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