Rules with fixing time Local-easy

Local change in a single location. For example adding a missing label.

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

  Maintainability
• G-2140 Never initialize variables with NULL.

  Maintainability
• G-2150 Avoid comparisons with NULL value, consider using IS [NOT] NULL.

  Reliability
• G-2160 Avoid initializing variables using functions in the declaration section.

  Reliability
• G-2180 Never use quoted identifiers.

  Maintainability
• G-2185 Avoid using overly short names for explicitly or implicitly declared identifiers.

  Maintainability
• G-2320 Never use VARCHAR data type.

  Maintainability
• G-2330 Never use zero-length strings to substitute NULL.

  Maintainability
• G-2340 Always define your VARCHAR2 variables using CHAR SEMANTIC (if not defined anchored).

  Reliability
• G-3180 Always specify column names instead of positional references in ORDER BY clauses.

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

  Maintainability
• G-4230 Always use a COALESCE instead of a NVL command, if parameter 2 of the NVL function is a function call or a SELECT statement.

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

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

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

  Maintainability
• G-7125 Always use CREATE OR REPLACE instead of CREATE alone.

  Maintainability
• G-7510 Always prefix Oracle supplied packages with owner schema name.

  Security
• G-7810 Never use SQL inside PL/SQL to read sequence numbers (or SYSDATE).

  Reliability
• 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-9208 Always follow naming conventions for assertions.

  Maintainability
• G-9213 Always follow naming conventions for triggers.

  Maintainability

27 total