Rules tagged with: General
General topics.
All 13 check SQL or PL/SQL code (G- codes). 6 also apply to PostgreSQL. Browse the rules below for explanations, examples and recommended fixes.
Most severe General rules
- G-1060 Avoid storing ROWIDs or UROWIDs in database tables. Blocker
- G-1080 Avoid using the same expression on both sides of a relational comparison operator or a logical operator. Blocker
- G-1920 Avoid syntax errors. Blocker
- G-0010 Always format database code consistently. Minor
- G-1010 Try to label your sub blocks. Minor
- G-1020 Always have a matching loop or block label. Minor
All 13 General rules
-
G-0010 Always format database code consistently.Minor Maintainability
-
G-1010 Try to label your sub blocks.Minor Maintainability
-
G-1020 Always have a matching loop or block label.Minor Maintainability
-
G-1030 Avoid defining variables that are not used.Minor Maintainability
-
G-1040 Avoid dead code.Minor Maintainability
-
G-1050 Avoid using literals in your code.Minor Maintainability
-
G-1060 Avoid storing ROWIDs or UROWIDs in database tables.Blocker Reliability
-
G-1070 Avoid nesting comment blocks.Minor Maintainability
-
G-1080 Avoid using the same expression on both sides of a relational comparison operator or a logical operator.Blocker Maintainability
-
G-1910 Avoid using the NOSONAR marker.Info Maintainability
-
G-1920 Avoid syntax errors.Blocker Maintainability
-
G-1930 Avoid long parsing times.Info Maintainability
-
G-1940 Avoid long checking times.Info Maintainability
13 total
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.