RetroSearch Browse

Showing content from https://docs.pmd-code.org/latest/pmd_rules_plsql.html below:

Index of all built-in rules available for PLSQL

Table of Contents Best Practices

Rules which enforce generally accepted best practices.

TomKytesDespair: "WHEN OTHERS THEN NULL" hides all errors - (Re)RAISE an exception or call RAISE_APPLICATION_ERROR

Code Style

Rules which enforce a specific coding style.

AvoidTabCharacter: This rule checks, that there are no tab characters (â\tâ) in the source file. It reports only theâ¦
CodeFormat: This rule verifies that the PLSQL code is properly formatted. The following checks are executed: â¦
ForLoopNaming: In case you have loops please name the loop variables more meaningful.
LineLength: This rule checks for long lines. Please note that comments are not ignored. This rule is the PMD â¦
MisplacedPragma: Oracle states that the PRAQMA AUTONOMOUS_TRANSACTION must be in the declaration block, but the coâ¦

Design

Rules that help you discover design issues.

CyclomaticComplexity: Complexity directly affects maintenance costs is determined by the number of decision points in aâ¦
ExcessiveMethodLength: When methods are excessively long this usually indicates that the method is doing more than its nâ¦
ExcessiveObjectLength: Excessive object line lengths are usually indications that the object may be burdened with excessâ¦
ExcessivePackageBodyLength: Excessive class file lengths are usually indications that the class may be burdened with excessivâ¦
ExcessivePackageSpecificationLength: Excessive class file lengths are usually indications that the class may be burdened with excessivâ¦
ExcessiveParameterList: Methods with numerous parameters are a challenge to maintain, especially if most of them share thâ¦
ExcessiveTypeLength: Excessive class file lengths are usually indications that the class may be burdened with excessivâ¦
NcssMethodCount: This rule uses the NCSS (Non-Commenting Source Statements) algorithm to determine the number of lâ¦
NcssObjectCount: This rule uses the NCSS (Non-Commenting Source Statements) algorithm to determine the number of lâ¦
NPathComplexity: The NPath complexity of a method is the number of acyclic execution paths through that method. A â¦
TooManyFields: Classes that have too many fields can become unwieldy and could be redesigned to have fewer fieldâ¦
TooManyMethods: A package or type with too many methods is probably a good suspect for refactoring, in order to râ¦

Error Prone

Rules to detect constructs that are either broken, extremely confusing or prone to runtime errors.

TO_DATE_TO_CHAR: TO_DATE(TO_CHAR(date-variable)) used to remove time component - use TRUNC(date-variable)
TO_DATEWithoutDateFormat: TO_DATE without date format- use TO_DATE(expression, date-format)
TO_TIMESTAMPWithoutDateFormat: TO_TIMESTAMP without date format- use TO_TIMESTAMP(expression, date-format)

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4