Rules with fixing time Local-medium

Local changes in a few locations. For example fix overladed local variable.

• G-1010Try to label your sub blocks.

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

  Maintainability
• G-1040Avoid dead code.

  Maintainability
• G-1050Avoid using literals in your code.

  Maintainability
• G-1070Avoid nesting comment blocks.

  Maintainability
• G-1080Avoid using the same expression on both sides of a relational comparison operator or a logical operator.

  Maintainability
• A-1130Always follow naming conventions for page items.

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

  Reliability
• G-2120Try to have a single location to define your types.

  Maintainability
• G-2130Try to use subtypes for constructs used often in your code.

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

  Reliability
• G-2145Never self-assign a variable.

  Maintainability
• G-2170Never overload variables.

  Maintainability
• G-2190Avoid using ROWID or UROWID.

  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-2310Avoid using CHAR data type.

  Reliability
• G-2410Try to use boolean data type for values with dual meaning.

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

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

  Maintainability
• G-3110Always specify the target columns when coding an insert statement.

  Reliability
• G-3115Avoid self-assigning a column.

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

  Reliability
• G-3182Always specify column names/aliases instead of positional references in GROUP BY clauses.

  Reliability
• G-3183Always specify column aliases instead of expressions in GROUP BY clauses.

  Maintainability
• G-3195Always use wildcards in a LIKE clause.

  Maintainability
• G-3310Never commit within a cursor loop.

  Reliability
• G-4120Avoid using %NOTFOUND directly after the FETCH when working with BULK OPERATIONS and LIMIT clause.

  Reliability
• G-4130Always close locally opened cursors.

  Reliability
• G-4140Avoid executing any statements between a SQL operation and the usage of an implicit cursor attribute.

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

  Maintainability
• 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-4250Avoid using identical conditions in different branches of the same IF or CASE statement.

  Maintainability
• G-4320Always label your loops.

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

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

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

  Maintainability
• G-4375Always use EXIT WHEN instead of an IF statement to exit from a loop.

  Maintainability
• G-4380Try to label your EXIT WHEN statements.

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

  Maintainability
• G-4387Never use a FOR LOOP for a query that should return not more than one row.

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

  Reliability
• G-4395Avoid hard-coded upper or lower bound values with FOR loops.

  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-5060Avoid unhandled exceptions.

  Reliability
• G-5070Avoid using Oracle predefined exceptions.

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

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

  Maintainability
• G-6020Try to use output bind arguments in the RETURNING INTO clause of dynamic DML statements rather than the USING clause.

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

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

  Maintainability
• G-7150Try to remove unused parameters.

  Maintainability
• G-7160Always explicitly state parameter mode.

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

  Reliability
• G-7220Always use forward declaration for private functions and procedures.

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

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

  Maintainability
• G-7330Always assign values to OUT parameters.

  Maintainability
• G-7450Never return a NULL value from a BOOLEAN function.

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

  Reliability
• G-7720Never use multiple UPDATE OF in trigger event clause.

  Maintainability
• G-7910Never use DML within a SQL macro.

  Reliability
• G-8310Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.

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

  Reliability
• G-9010Always use a format model in string to date/time conversion functions.

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

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

  Maintainability
• G-9040Try using FX in string to date/time conversion format model to avoid fuzzy conversion.

  Reliability
• G-9501Never use parameter in string expression of dynamic SQL. Use asserted local variable instead.

  Security
• 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

78 total