Rules with severity level Minor

Will have a low impact on the maintenance cost. No impact on the runtime behavior.

• G-1010 Try to label your sub blocks.

  Maintainability
• G-1020 Always have a matching loop or block label.

  Maintainability
• G-1030 Avoid defining variables that are not used.

  Maintainability
• G-1040 Avoid dead code.

  Maintainability
• G-1050 Avoid using literals in your code.

  Maintainability
• G-1070 Avoid nesting comment blocks.

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

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

  Maintainability
• G-2120 Try to have a single location to define your types.

  Maintainability
• G-2130 Try to use subtypes for constructs used often in your code.

  Maintainability
• G-2140 Never initialize variables with NULL.

  Maintainability
• G-2410 Try to use boolean data type for values with dual meaning.

  Maintainability
• G-2610 Never use self-defined weak ref cursor types.

  Maintainability
• G-3183 Always specify column aliases instead of expressions in GROUP BY clauses.

  Maintainability
• G-4110 Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor returned data.

  Maintainability
• G-4210 Try to use CASE rather than an IF statement with multiple ELSIF paths.

  Maintainability
• G-4260 Avoid inverting boolean conditions with NOT.

  Maintainability
• G-4270 Avoid comparing boolean values to boolean literals.

  Maintainability
• G-4320 Always label your loops.

  Maintainability
• G-4375 Always use EXIT WHEN instead of an IF statement to exit from a loop.

  Maintainability
• G-4380 Try to label your EXIT WHEN statements.

  Maintainability
• G-4395 Avoid hard-coded upper or lower bound values with FOR loops.

  Maintainability
• G-6020 Try to use output bind arguments in the RETURNING INTO clause of dynamic DML statements rather than the USING clause.

  Maintainability
• G-7120 Always add the name of the program unit to its end keyword.

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

  Reliability
• G-7220 Always use forward declaration for private functions and procedures.

  Maintainability
• G-7310 Avoid standalone procedures – put your procedures in packages.

  Maintainability
• G-7410 Avoid standalone functions – put your functions in packages.

  Maintainability
• G-7730 Avoid multiple DML events per trigger.

  Reliability
• G-8210 Always use synonyms when accessing objects of another application schema.

  Maintainability
• G-8310 Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.

  Maintainability
• G-9101 Always follow naming conventions for global variables.

  Maintainability
• G-9102 Always follow naming conventions for local variables.

  Maintainability
• G-9103 Always follow naming conventions for cursor variables.

  Maintainability
• G-9104 Always follow naming conventions for record variables.

  Maintainability
• G-9105 Always follow naming conventions for collection variables (arrays/tables).

  Maintainability
• G-9106 Always follow naming conventions for object variables.

  Maintainability
• G-9107 Always follow naming conventions for cursor parameters.

  Maintainability
• 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-9203 Always follow naming conventions for indexes.

  Maintainability
• G-9204 Always follow naming conventions for primary key constraints.

  Maintainability
• G-9205 Always follow naming conventions for unique constraints.

  Maintainability
• G-9206 Always follow naming conventions for foreign key constraints.

  Maintainability
• G-9207 Always follow naming conventions for check constraints.

  Maintainability
• G-9208 Always follow naming conventions for assertions.

  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-9213 Always follow naming conventions for triggers.

  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

66 total