Rules tagged with: Naming PL/SQL
Naming conventions for PL/SQL identifiers.
All 16 check SQL or PL/SQL code (G- codes). Browse the rules below for explanations, examples and recommended fixes.
Most severe Naming PL/SQL rules
- G-9101 Always follow naming conventions for global variables. Minor
- G-9102 Always follow naming conventions for local variables. Minor
- G-9103 Always follow naming conventions for cursor variables. Minor
- G-9104 Always follow naming conventions for record variables. Minor
- G-9105 Always follow naming conventions for collection variables (arrays/tables). Minor
- G-9106 Always follow naming conventions for object variables. Minor
All 16 Naming PL/SQL rules
-
G-9101 Always follow naming conventions for global variables.Minor Maintainability
-
G-9102 Always follow naming conventions for local variables.Minor Maintainability
-
G-9103 Always follow naming conventions for cursor variables.Minor Maintainability
-
G-9104 Always follow naming conventions for record variables.Minor Maintainability
-
G-9105 Always follow naming conventions for collection variables (arrays/tables).Minor Maintainability
-
G-9106 Always follow naming conventions for object variables.Minor Maintainability
-
G-9107 Always follow naming conventions for cursor parameters.Minor Maintainability
-
G-9108 Always follow naming conventions for IN parameters of functions and procedures.Minor Maintainability
-
G-9109 Always follow naming conventions for OUT parameters of functions and procedures.Minor Maintainability
-
G-9110 Always follow naming conventions for IN/OUT parameters of functions and procedures.Minor Maintainability
-
G-9111 Always follow naming conventions for record type definitions.Minor Maintainability
-
G-9112 Always follow naming conventions for collection type definitions (arrays/tables).Minor Maintainability
-
G-9113 Always follow naming conventions for exceptions.Minor Maintainability
-
G-9114 Always follow naming conventions for constants.Minor Maintainability
-
G-9115 Always follow naming conventions for subtypes.Minor Maintainability
-
G-9116 Always follow naming conventions for record fields.Minor Maintainability
16 total
Related tags
Tags that appear on the same rules as Naming PL/SQL:
- DD Query (2 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.