G-9209 – Always follow naming conventions for global temporary tables.

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`

Tags: Naming SQL.

Quality area: Maintainability. Severity: Minor. Fixing time: Other.