rules repository

G-9209

🆓
Warning

Always follow naming conventions for global temporary tables.

Naming SQL

Rule Details

Severity Level
Minor
Quality Area
Maintainability
Fixing times
60 mins
Other
Database Support
OracleDB (v8.1.5 +)

Reason

SQL identifiers share the same namespace as PL/SQL identifiers. Follow naming conventions to prevent naming conflicts, improve readability, and clearly indicate the scope without forcing the use of qualified names. A common practice is to use a prefix and/or suffix to distinguish the identifier types.

Recommendations

Naming as described for tables.

Optionally suffixed by _tmp

Optionally prefixed by a project abbreviation.

Examples

  • employees_tmp
  • contracts_tmp

Example

Non-Compliant Example

create global temporary table département_tmp (
    id number(8,0) not null
    -- ...
) on commit preserve rows;
Issues
LineColumnMessage
131global temporary table département_tmp does not match '(?i)^[a-z][a-z0-9$#_]*$'.

We do not want accented letters in table names.

Compliant Solution - ★★★★★

create global temporary table departement_tmp (
    id number(8,0) not null
    -- ...
) on commit preserve rows;

All accented letters are replaced with plain Latin letters.

Parameters

Use parameters to customize the rule to your needs.

ParameterDescriptionDefault Value
GlobalTemporaryTablePatternRegular expression pattern for SQL global temporary tables.(?i)^[a-z][a-z0-9$#_]*$

References

← Previous
G-9208
Always follow naming conventions for assertions.
Next →
G-9210
Always follow naming conventions for views.