Balanced profile

Good practice, low controversy.

34 rules added by Balanced

Balanced also enables every rule of Essential — 97 rules in total.

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

  Minor Maintainability
• G-1040 Avoid dead code.

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

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

  Blocker Reliability
• G-2135 Avoid assigning values to local variables that are not used by a subsequent statement.

  Major Reliability
• G-2140 Never initialize variables with NULL.

  Minor Maintainability
• G-2170 Never overload variables.

  Major Maintainability
• G-2180 Never use quoted identifiers.

  Major Maintainability
• G-2210 Avoid declaring NUMBER variables, constants or subtypes with no precision.

  Critical Reliability
• G-2220 Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.

  Critical Reliability
• G-2230 Try to use SIMPLE_INTEGER datatype when appropriate.

  Critical Reliability
• G-2510 Avoid using the LONG and LONG RAW data types.

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

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

  Major Reliability
• G-4310 Never use GOTO statements in your code.

  Major Maintainability
• G-4325 Never reuse labels in inner scope.

  Major Maintainability
• G-4360 Always use a WHILE loop to process a loose array.

  Critical Reliability
• G-4385 Never use a cursor for loop to check whether a cursor returns data.

  Critical Maintainability
• G-7140 Always ensure that locally defined procedures or functions are referenced.

  Major Maintainability
• G-7230 Avoid declaring global variables public.

  Major Reliability
• G-8110 Never use SELECT COUNT(*) if you are only interested in the existence of a row.

  Critical Reliability
• A-0730 Always give an alias to pages.

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

  Major Reliability
• A-1250 New Avoid components with the condition type "Never".

  Minor Maintainability
• A-1390 New Avoid buttons defined by dynamic action without a dynamic action.

  Major Reliability
• A-1400 New Never keep the default name New for components.

  Minor Maintainability
• 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-2420 New Avoid regions without a template.

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

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

  Major Reliability
• A-3100 New Avoid LOV items on single-column Interactive Grid primary keys.

  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

34 total