Rules with severity level Major

Will have a medium/potential impact on the maintenance cost. May have an impact on runtime behavior; for example, higher memory consumption.

• G-1220 Avoid composite primary keys.

  Maintainability
• G-1230 Avoid tables without relationships.

  Maintainability
• G-1240 Try to index foreign key columns.

  Reliability
• G-1250 Try to define a business key for each table.

  Reliability
• G-2110 Try to use anchored declarations for variables, constants and types.

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

  Reliability
• G-2170 Never overload variables.

  Maintainability
• G-2180 Never use quoted identifiers.

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

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

  Maintainability
• G-3130 Try to use ANSI SQL-92 join syntax.

  Maintainability
• G-3140 Try to use anchored records as targets for your cursors.

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

  Reliability
• G-3320 Try to move transactions within a non-cursor loop into procedures.

  Maintainability
• G-4220 Try to use CASE rather than DECODE.

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

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

  Maintainability
• G-4330 Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations.

  Maintainability
• G-4340 Always use a NUMERIC FOR loop to process a dense array.

  Maintainability
• G-4365 Never use unconditional CONTINUE or EXIT in a loop.

  Maintainability
• G-4370 Avoid using EXIT to stop loop processing unless you are in a basic loop.

  Maintainability
• G-4390 Avoid use of unreferenced FOR loop indexes.

  Reliability
• G-5050 Avoid use of the RAISE_APPLICATION_ERROR built-in procedure with a hard-coded 20nnn error number or hard-coded message.

  Maintainability
• G-5060 Avoid unhandled exceptions.

  Reliability
• G-6010 Always use a character variable to execute dynamic SQL.

  Maintainability
• G-7110 Try to use named notation when calling program units.

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

  Maintainability
• G-7130 Always use parameters or pull in definitions rather than referencing external variables in a local program unit.

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

  Maintainability
• G-7150 Try to remove unused parameters.

  Maintainability
• G-7160 Always explicitly state parameter mode.

  Reliability
• G-7170 Avoid using an IN OUT parameter as IN or OUT only.

  Reliability
• G-7230 Avoid declaring global variables public.

  Reliability
• G-7250 Never use RETURN in package initialization block.

  Reliability
• G-7320 Avoid using RETURN statements in a PROCEDURE.

  Maintainability
• G-7420 Always make the RETURN statement the last statement of your function.

  Maintainability
• G-7430 Try to use no more than one RETURN statement within a function.

  Maintainability
• G-7440 Never use OUT parameters to return values from a function.

  Maintainability
• G-7460 Try to define your packaged/standalone function deterministic if appropriate.

  Reliability
• G-7520 Avoid using deprecated units in your own code.

  Maintainability
• G-7710 Avoid cascading triggers.

  Maintainability
• G-9030 Try to define a default value on conversion errors.

  Maintainability

42 total