Major

Code Rules in Major Severity

Category Severity Name Description
Bug Major All branches in a conditional structure should not have exactly the same implementation All branches in a conditional structure should not have exactly the same implementation
Maintainability Major CASE should be used rather than DECODE CASE should be used rather than DECODE
Maintainability Major CASE structures should not have too many WHEN clauses CASE structures should not have too many WHEN clauses
Maintainability Major Collapsible if statements should be merged Collapsible if statements should be merged
Maintainability Major Column aliases should be defined using AS Column aliases should be defined using AS
Maintainability Major Column names should be used in a SQL ORDER BY clause Column names should be used in a SQL ORDER BY clause
Maintainability Major Columns should be aliased Columns should be aliased
Maintainability Major Columns to be read with a SELECT statement should be clearly defined Columns to be read with a SELECT statement should be clearly defined
Maintainability Major Compound triggers should define at least two triggers Compound triggers should define at least two triggers
Maintainability Major CREATE_TIMER should not be used CREATE_TIMER should not be used
Maintainability Major CROSS JOIN queries should not be used CROSS JOIN queries should not be used
Maintainability Major Dead stores should be removed Dead stores should be removed
Maintainability Major Deprecated LONG and LONG RAW datatypes should no longer be used Deprecated LONG and LONG RAW datatypes should no longer be used
Bug Major DML events clauses should not include multiple OF clauses DML events clauses should not include multiple OF clauses
Maintainability Major END statements of labeled blocks should be labeled END statements of labeled blocks should be labeled
Maintainability Major END statements of labeled loops should be labeled END statements of labeled loops should be labeled
Maintainability Major EXECUTE IMMEDIATE should be used instead of DBMS_SQL procedure calls EXECUTE IMMEDIATE should be used instead of DBMS_SQL procedure calls
Maintainability Major EXIT WHEN should be used rather than IF ... THEN EXIT; END IF EXIT WHEN should be used rather than IF ... THEN EXIT; END IF
Maintainability Major Features deprecated in Oracle 12 should not be used Features deprecated in Oracle 12 should not be used
Maintainability Major FETCH ... BULK COLLECT INTO should be used FETCH ... BULK COLLECT INTO should be used
Maintainability Major Files should not have too many lines of code Files should not have too many lines of code
Maintainability Major FOR loop end conditions should not be hard - coded FOR loop end conditions should not be hard - coded
Maintainability Major FORALL should be used FORALL should be used
Maintainability Major FULL OUTER JOINS should be used with caution FULL OUTER JOINS should be used with caution
Maintainability Major Function and procedure names should comply with a naming convention Function and procedure names should comply with a naming convention
Maintainability Major Function and procedure parameters should comply with a naming convention Function and procedure parameters should comply with a naming convention
Maintainability Major Functions and procedures should not have too many parameters Functions and procedures should not have too many parameters
Maintainability Major FUNCTIONS should not have OUT parameters FUNCTIONS should not have OUT parameters
Maintainability Major GOTO should not be used within loops GOTO should not be used within loops
Maintainability Major GOTO statements should not be used GOTO statements should not be used
Maintainability Major GROUP BY should not be used in SQL SELECT statements GROUP BY should not be used in SQL SELECT statements
Bug Major Identical expressions should not be used on both sides of a binary operator Identical expressions should not be used on both sides of a binary operator
Bug Major IF statement conditions should not evaluate unconditionally to TRUE or to FALSE IF statement conditions should not evaluate unconditionally to TRUE or to FALSE
Maintainability Major In labeled loops EXIT should exit the label In labeled loops EXIT should exit the label
Bug Major Jump statements should not be followed by dead code Jump statements should not be followed by dead code
Maintainability Major Labels redefined in inner scopes Labels should not be re-defined in inner scopes
Maintainability Major Large item lists should not be used with IN clauses Large item lists should not be used with IN clauses
Maintainability Major LIKE clauses should not start with wildcard characters LIKE clauses should not start with wildcard characters
Maintainability Major Lines should not be too long Lines should not be too long
Bug Major Loops with at most one iteration should be refactored Loops with at most one iteration should be refactored
Maintainability Major Magic numbers should not be used Magic numbers should not be used
Bug Major MLSLABEL should not be used MLSLABEL should not be used
Maintainability Major Native SQL joins should be used Native SQL joins should be used
Maintainability Major NATURAL JOIN queries should not be used NATURAL JOIN queries should not be used
Maintainability Major Nested blocks should be labeled Nested blocks should be labeled
Maintainability Major Nested loops should be labeled Nested loops should be labeled
Maintainability Major Nested subqueries should be avoided Nested subqueries should be avoided
Bug Major NULL should not be compared directly NULL should not be compared directly
Maintainability Major NUMBER variables should be declared with precision NUMBER variables should be declared with precision
Bug Major Output parameters should be assigned Output parameters should be assigned
Bug Major PACKAGE BODY initialization sections should not contain RETURN statements PACKAGE BODY initialization sections should not contain RETURN statements
Maintainability Major Procedures and functions should be encapsulated in packages Procedures and functions should be encapsulated in packages
Maintainability Major Procedures should have parameters Procedures should have parameters
Maintainability Major Queries should not SELECT too many columns Queries should not SELECT too many columns
Maintainability Major Redundant pairs of parentheses should be removed Redundant pairs of parentheses should be removed
Bug Major Related IF / ELSIF statements and WHEN clauses in a CASE should not have the same condition Related IF / ELSIF statements and WHEN clauses in a CASE should not have the same condition
Maintainability Major RESULT_CACHE should not be used RESULT_CACHE should not be used
Maintainability Major ROWID and UROWID data types should not be used ROWID and UROWID data types should not be used
Bug Major ROWNUM should not be used at the same query level as ORDER BY ROWNUM should not be used at the same query level as ORDER BY
Maintainability Major SIMPLE_INTEGER should be used instead of PLS_INTEGER SIMPLE_INTEGER should be used instead of PLS_INTEGER
Maintainability Major SQL EXISTS subqueries should not be used SQL EXISTS subqueries should not be used
Maintainability Major SQL statements should not join too many tables SQL statements should not join too many tables
Maintainability Major Statements should be on separate lines Statements should be on separate lines
Bug Major Strings should only be moved to variables or columns which are large enough to hold them Strings should only be moved to variables or columns which are large enough to hold them
Maintainability Major Tables should be aliased Tables should be aliased
Bug Major The result_cache hint should be avoided The result_cache hint should be avoided
Maintainability Major TO_DATE and TO_TIMESTAMP should be used with a datetime format model TO_DATE and TO_TIMESTAMP should be used with a datetime format model
Maintainability Major TO_NUMBER should be used with a format model TO_NUMBER should be used with a format model
Maintainability Major Track breaches of an XPath rule Track breaches of an XPath rule
Maintainability Major Track comments matching a regular expression Track comments matching a regular expression
Maintainability Major Track uses of FIXME tags Track uses of FIXME tags
Maintainability Major Track uses of NOSONAR comments Track uses of NOSONAR comments
Maintainability Major Two branches in a conditional structure should not have exactly the same implementation Two branches in a conditional structure should not have exactly the same implementation
Bug Major Unary prefix operators should not be repeated Unary prefix operators should not be repeated
Maintainability Major UNION should be used with caution UNION should be used with caution
Maintainability Major Unused labels should be removed Unused labels should be removed
Maintainability Major Unused Procedure and Function Parameters Unused procedure and function parameters should be removed
Bug Major VARCHAR2 and NVARCHAR2 should be used VARCHAR2 and NVARCHAR2 should be used
Maintainability Major VARCHAR2 should be used VARCHAR2 should be used
Bug Major Variables and columns should not be self-assigned Variables and columns should not be self-assigned
Maintainability Major Variables should be nullable Variables should be nullable
Maintainability Major WHEN clauses should not have too many lines WHEN clauses should not have too many lines
Bug Major WHERE clause conditions should not be contradictory WHERE clause conditions should not be contradictory