Rules with fixing time Local-easy

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

• G-0010 Always format database code consistently.

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

  Minor Maintainability
• G-2140 Never initialize variables with NULL.

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

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

  Critical Reliability
• G-2180 Never use quoted identifiers.

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

  Major Maintainability
• G-2320 Never use VARCHAR data type.

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

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

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

  Major Reliability
• G-3194 Always specify INNER or OUTER within JOIN TO ONE.

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

  Minor 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  Blocker Security
• A-0720 Always enable Page Access Protection.

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

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

  Blocker Security
• A-0960 New Try to give modal dialogs a Cancel button.

  Minor Maintainability
• A-0970 New Never place branches after an unconditional branch.

  Major Reliability
• A-1060 New Try to assign applications to an application group.

  Minor Maintainability
• A-1070 New Always reload pages with editable Interactive Grids only for success.

  Blocker Reliability
• A-1100 New Try to keep hidden page items protected.

  Blocker Security
• A-1120 New Always define an icon for buttons using an icon template.

  Minor Maintainability
• A-1140 New Try to assign pages to a page group.

  Minor Maintainability
• A-1250 New Avoid components with the condition type "Never".

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

  Critical Security
• A-1390 New Avoid buttons defined by dynamic action without a dynamic action.

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

  Critical Security
• A-1750 New Avoid static lists without entries.

  Major Reliability
• A-1860 New Avoid NOT NULL validations; use the item's Value Required setting.

  Minor Maintainability
• A-2300 New Never use the HTML (Unsafe) format on Display-Only items.

  Critical Security
• A-2420 New Avoid regions without a template.

  Minor Maintainability
• A-2430 New Avoid page items without a label template.

  Minor Maintainability
• A-3060 New Always define a primary key column for editable Interactive Grids.

  Blocker Reliability
• A-3070 New Try to define a default value for Interactive Grid checkbox and switch columns.

  Minor Maintainability
• A-3080 New Avoid making Interactive Grid columns read-only with CSS only.

  Blocker Security
• A-3090 New Never mark Interactive Grid columns with the is-readonly class as required.

  Major Reliability
• A-3110 New Always define a primary key item for forms with a DML process.

  Blocker Reliability
• A-3130 New Always define a primary key column for master Interactive Grids.

  Blocker Reliability
• A-3150 New Avoid a null entry on required LOV items and Interactive Grid columns.

  Minor Maintainability
• A-3160 New Try to give regions an HTML DOM ID.

  Minor Maintainability
• A-3190 New Try to use a required label template for required page items.

  Minor Maintainability
• A-3220 New Avoid regions in the dialogs position without a dialog template.

  Major Reliability

61 total