Visual Expert Rules

Minor

Code Rules in Minor Severity

Category Severity Name Description
Maintainability Minor An ORDER BY direction should be specified explicitly An ORDER BY direction should be specified explicitly
Maintainability Minor Boolean checks should not be inverted Boolean checks should not be inverted
Maintainability Minor Boolean literals should not be redundant Boolean literals should not be redundant
Maintainability Minor CASE should be used for sequences of simple tests CASE should be used for sequences of simple tests
Maintainability Minor Comments should not be located at the end of lines of code Comments should not be located at the end of lines of code
Maintainability Minor Comments should not be nested Comments should not be nested
Maintainability Minor Constraint names should comply with a naming convention Constraint names should comply with a naming convention
Maintainability Minor Cursor parameters should follow a naming convention Cursor parameters should follow a naming convention
Maintainability Minor cursor%NOTFOUND should be used instead of NOT cursor%FOUND cursor%NOTFOUND should be used instead of NOT cursor%FOUND
Maintainability Minor Cursors should follow a naming convention Cursors should follow a naming convention
Maintainability Minor DBMS_UTILITY.FORMAT_ERROR_STACK and FORMAT_ERROR_BACKTRACE should be used together DBMS_UTILITY.FORMAT_ERROR_STACK and FORMAT_ERROR_BACKTRACE should be used together
Maintainability Minor Empty Method Empty Method
Maintainability Minor EXCEPTION WHEN ... THEN clauses should do more than EXCEPTION WHEN ... THEN clauses should do more than RAISE
Maintainability Minor Exceptions should follow a naming convention Exceptions should follow a naming convention
Maintainability Minor EXIT should not be used in loops EXIT should not be used in loops
Bug Minor Explicitly opened cursors should be closed Explicitly opened cursors should be closed
Maintainability Minor Identifiers should be written in lower case Identifiers should be written in lower case
Maintainability Minor Jump statements should not be redundant Jump statements should not be redundant
Maintainability Minor Large Scripts Large Scripts
Maintainability Minor Lines in a multiline comment should start with * Lines in a multiline comment should start with *
Maintainability Minor Object attributes should comply with a naming convention Object attributes should comply with a naming convention
Maintainability Minor Oracle's join operator (+) should not be used Oracle's join operator (+) should not be used
Maintainability Minor Package names should comply with a naming convention Package names should comply with a naming convention
Maintainability Minor Parameter IN mode should be specified explicitly Parameter IN mode should be specified explicitly
Maintainability Minor PLS_INTEGER types should be used PLS_INTEGER types should be used
Maintainability Minor Procedures should not contain RETURN statements Procedures should not contain RETURN statements
Maintainability Minor Record fields should comply with a naming convention Record fields should comply with a naming convention
Maintainability Minor Return of boolean expressions should not be wrapped into an if-then -else statement Return of boolean expressions should not be wrapped into an if-then -else statement
Maintainability Minor Single line comments should start with -- Single line comments should start with --
Maintainability Minor SQL tables should be joined with the JOIN keyword SQL tables should be joined with the JOIN keyword
Maintainability Minor The RELIES_ON clause should not be used The RELIES_ON clause should not be used
Maintainability Minor Types should follow a naming convention Types should follow a naming convention
Maintainability Minor Uncommented scripts Uncommented scripts
Maintainability Minor Unused local variables should be removed Unused local variables should be removed
Maintainability Minor Variables Naming Convention Variables should comply with a naming convention
Maintainability Minor Variables should not be initialized with NULL Variables should not be initialized with NULL