Rules with fixing time Other

Local change and changes in other modules. For example, replace the use of ROWID with primary keys in tables and code.

• G-1060 Avoid storing ROWIDs or UROWIDs in database tables.

  Reliability
• G-1110 Avoid connect users that own database objects.

  Security
• G-1120 Avoid granting system privileges to connect users.

  Security
• G-1130 Avoid granting table access to API roles.

  Maintainability
• G-1140 Avoid granting object privileges directly to connect users.

  Maintainability
• G-1150 Always limit privileges of schema owners according to principle of least privileges.

  Security
• G-1210 Never create a table without a primary key.

  Reliability
• G-1220 Avoid composite primary keys.

  Maintainability
• G-1230 Avoid tables without relationships.

  Maintainability
• G-1240 Try to index foreign key columns.

  Reliability
• G-1250 Try to define a business key for each table.

  Reliability
• G-1260 Try to define a comment for each table.

  Maintainability
• G-1270 Try to define a comment for each column.

  Maintainability
• G-1280 Try to use domains instead of raw datatypes for table columns.

  Maintainability
• G-1310 Never keep database objects in an invalid state.

  Reliability
• G-3150 Try to use identity columns for surrogate keys.

  Reliability
• G-3160 Avoid visible virtual columns.

  Reliability
• G-3170 Always use DEFAULT ON NULL declarations to assign default values to table columns if you refuse to store NULL values.

  Reliability
• G-3330 Avoid autonomous transactions.

  Reliability
• G-7210 Try to keep your packages small. Include only few procedures and functions that are used in the same context.

  Reliability
• G-9108 Always follow naming conventions for IN parameters of functions and procedures.

  Maintainability
• G-9109 Always follow naming conventions for OUT parameters of functions and procedures.

  Maintainability
• G-9110 Always follow naming conventions for IN/OUT parameters of functions and procedures.

  Maintainability
• G-9111 Always follow naming conventions for record type definitions.

  Maintainability
• G-9112 Always follow naming conventions for collection type definitions (arrays/tables).

  Maintainability
• G-9113 Always follow naming conventions for exceptions.

  Maintainability
• G-9114 Always follow naming conventions for constants.

  Maintainability
• G-9115 Always follow naming conventions for subtypes.

  Maintainability
• G-9116 Always follow naming conventions for record fields.

  Maintainability
• G-9201 Always follow naming conventions for tables.

  Maintainability
• G-9202 Always follow naming conventions for table/view columns.

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

  Maintainability
• G-9210 Always follow naming conventions for views.

  Maintainability
• G-9211 Always follow naming conventions for sequences.

  Maintainability
• G-9212 Always follow naming conventions for synonyms.

  Maintainability
• G-9214 Always follow naming conventions for PL/SQL packages.

  Maintainability
• G-9215 Always follow naming conventions for functions.

  Maintainability
• G-9216 Always follow naming conventions for procedures.

  Maintainability
• G-9217 Always follow naming conventions for object types.

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

  Maintainability
• G-9219 Always follow naming conventions for collection type.

  Maintainability

41 total