G-9219 – Always follow naming conventions for collection types.

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** A collection type should include the name of the collected objects in their name. Furthermore, they should have the suffix `_ct` to identify it as a collection. Optionally prefixed by a project abbreviation. **Examples** * `employees_ct` * `orders_ct`

Tags: Naming SQL.

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