PL/SQL Cop for SQL Developer v1.0.8

• Released on 2015-04-06
• Oracle 12.1.0.2 grammar support (SQL*Plus, SQL and PL/SQL), e.g.
  • JSON
    • IS JSON condition
    • JSON_EXISTS condition
    • JSON_TEXTCONTAINS condition
    • JSON_QUERY
    • JSON_TABLE
    • JSON_VALUE
  • ZONE MAPS
    • CREATE MATERIALIZED ZONEMAP
    • ALTER MATERIALIZED ZONEMAP
    • DROP MATERIALIZED ZONEMAP
• Rating system for complexity metrics
  • Green, amber, red for
    • McCabe’s cyclomatic complexity
    • Halstead volume
    • Maintainability index
  • Legend explaining the rating system
• Additional metrics
  • lines of comments
  • blank lines
  • net lines of code (lines of code without blank lines and comment lines)
• Grammar fixes (supporting additional keywords such ass RULES, INTERFACE)
• Suppress warnings if errors are reported
• Changed context of guideline 60 (Try to use named notation when calling program units)
• Fixed false positives on guideline 42 (Always use a NUMERIC FOR loop to process a dense array)
• Fixed false positives on guideline 03 (Avoid defining variables that are not used) for variables or constants used in cursors only
• Fixed false positives on guideline 62 (Always use parameters or pull in definitions rather than referencing external variables) when sequence pseudocolumns CURRVAL and NEXTVAL are used
• Fixed non-working NOSONAR marker with a preceding comment
• Fixed wrong line number if analyzed statement starts with one or more new lines