Rules with severity level Critical

Will have a high/direct impact on the maintenance cost. May have an impact on runtime behavior; for example, incomplete audit data or slower runtime performance.

• G-1130Avoid granting table access to API roles.

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

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

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

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

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

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

  Reliability
• G-3150Try to use identity columns for surrogate keys.

  Reliability
• G-3210Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.

  Reliability
• G-3220Always process saved exceptions from a FORALL statement.

  Reliability
• 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-4240Always use a CASE instead of a NVL2 command if parameter 2 or 3 of NVL2 is either a function call or a SELECT statement.

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

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

  Maintainability
• G-5010Try to use a error/logging framework for your application.

  Reliability
• G-5020Never handle unnamed exceptions using the error number.

  Maintainability
• G-5040Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.

  Reliability
• G-5080Always use FORMAT_ERROR_BACKTRACE when using FORMAT_ERROR_STACK or SQLERRM.

  Maintainability
• G-7180Try to keep the complexity of functions, procedures and triggers simple.

  Maintainability
• G-7740Never handle multiple DML events per trigger if primary key is assigned in trigger.

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

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

  Reliability
• G-8120Never check existence of a row to decide whether to create it or not.

  Reliability
• G-8510Always use dbms_application_info to track program process transiently.

  Reliability
• G-9020Try to use a format model and NLS_NUMERIC_CHARACTERS in string to number conversion functions.

  Reliability
• G-9600Never define more than one comment with hints.

  Reliability
• G-9601Never use unknown hints.

  Reliability
• G-9602Always use the alias name instead of the table name.

  Reliability
• G-9603Never reference an unknown table/alias.

  Reliability
• G-9604Never use an invalid stats method.

  Reliability
• G-9605Never use an invalid stats keyword.

  Reliability

31 total