Rules with fixing time Local-easy

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

• A-0700Always enable Session State Protection at the application level.

  Security
• A-0720Always enable Page Access Protection.

  Security
• A-0730Always give an alias to pages.

  Maintainability
• A-0770Never allow application pages within an HTML frame.

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

  Maintainability
• A-1340Avoid pages without an authorization scheme.

  Security
• A-1410Never set session lifetime or idle time to 0 (unlimited).

  Security
• G-2140Never initialize variables with NULL.

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

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

  Reliability
• G-2180Never use quoted identifiers.

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

  Maintainability
• G-2320Never use VARCHAR data type.

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

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

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

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

  Maintainability
• G-4230Always 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-4260Avoid inverting boolean conditions with NOT.

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

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

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

  Maintainability
• G-7127Always use the FORCE option when creating views.

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

  Security
• G-7515Always prefix Oracle supplied object types with owner schema name.

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

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

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

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

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

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

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

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

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

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

  Maintainability

35 total