Rules tagged with: DD Query
For optimum results, the check requires access to the data dictionary. Therefore, a read-only connection must be configured.
All 4 check SQL or PL/SQL code (G- codes). Browse the rules below for explanations, examples and recommended fixes.
All 4 DD Query rules
-
G-7710 Avoid cascading triggers.Major Maintainability
-
G-7740 Never handle multiple DML events per trigger if primary key is assigned in trigger.Critical Reliability
-
G-9105 Always follow naming conventions for collection variables (arrays/tables).Minor Maintainability
-
G-9106 Always follow naming conventions for object variables.Minor Maintainability
4 total
Related tags
Tags that appear on the same rules as DD Query:
- Naming PL/SQL (2 shared)
- Stored Object (2 shared)
- Performance (1 shared)
More ways to browse rules
- Trivadis PL/SQL & SQL guideline rules - Rules that implement the Trivadis coding guidelines.
- OWASP-related security rules - Rules that name an OWASP Top 10 risk category.
- Oracle APEX rules - Checks for APEX applications, pages, items and regions.
- PostgreSQL rules - Rules that also apply to PostgreSQL and PL/pgSQL.
- Security rules - All rules in the Security quality area.
- Reliability rules - Rules that prevent bugs and failures at run time.
- Maintainability rules - Rules for code that is easy to read and change.
- Rules by quality area - Security, reliability and maintainability.
- Rules by severity - From Blocker to Info.
- Rule profiles - Essential to Extreme: which rules are checked.
- All rules - Search and filter the complete rule set.