G-9218 – Always follow naming conventions for object type attributes.

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** Singular name of what is stored in the attribute (unless the attribute data type is a collection, in this case you use plural names).

Tags: Naming SQL.

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