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