PL/SQL Analyzer v1.4.0

• Released on 2019-09-26
• Changed
  • PL/SQL grammar
    • Support keyword MOD and other keywords as query_name in the subquery_factoring_clause.
    • Support keyword ONE, e.g. as column alias.
    • Support keyword WELLFORMED, e.g. as parameter name.
    • Support keyword WORK, e.g. as parameter name.
  • Expose hints as new class named HintOrComment.
    • Customer have now access to source code details (e.g. start line, offset, etc.) via the PL/SQL parser.
    • This leads to a changed XML output structure (attribute instead of node).
    • The XPath expression to access hints changed from text() to @text.
  • Increased metadata versions
    • for database code to 9
    • for XML structure to 9
    • updates are installed on the first run
    • all source is processed on the first run
  • Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.12
  • Included preview/trial license is valid thru 2020-03-31
• Fixed
  • Parse error when using udf_pragma.
  • Parse error when using record with dot notation in values_clause of INSERT statement. For example INSERT INTO t VALUES in_param.rec.
  • Parse error when using NOT in expressions with A SET, NAN, INFINITE, PRESENT, EMPTY, JSON, OF TYPE. Fore example x IS NOT A SET.
• Won’t Fix
  • Support of keyword JSON in table name or table alias due to conflicts with JSON_condition.
  • Empty conditional compilation branches (see also Parser Limitations)

PL/SQL Analyzer v1.3.0

• Released on 2019-04-04
• Fixed
  • PL/SQL grammar
    • Parse error when using PRAGMA INLINE with a second string parameter.
• Changed
  • PL/SQL grammar
    • Support keyword EXCLUDE, e.g. as procedure name.
    • Support keyword INSTANTIABLE, e.g. as column name.
    • Support quote literal character / (see also Parser Limitations)
  • SQL*Plus grammar
    • Support $ as alias for HOST command.
  • Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.10
  • Included preview/trial license is valid thru 2019-09-30

PL/SQL Analyzer v1.2.4

• Released on 2018-09-10
• Changed
  • Included preview/trial license is valid thru 2019-03-31

PL/SQL Analyzer v1.2.3

• Released on 2017-09-22
• Fixed:
  • Using quote delimiter character ~ (tilde) leads to parse errors
  • Parse error when using COUNT in pivot_clause

PL/SQL Analyzer v1.2.2

• Released on 2017-08-15
• Fixed:
  • Using concatenation operator || with whitespace between the vertical bars leads to parse errors
• Changed
  • Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.7
  • Documented limitation regarding error_logging_clause, see Parser Limitations for examples

PL/SQL Analyzer v1.2.0

• Released on 2017-05-14
• New:
  • Oracle 12.2.0.1 grammar support
    • SQL*Plus
      • History command
    • SQL
      • Analytic views
      • Join groups
      • Oracle sharding
      • PDB lockdown profiles
      • ADMINISTER KEY MANAGEMENT Enhancements
      • FLASHBACK DATABASE Enhancement
      • SELECT Enhancement
      • New COLLATE Operator
      • New or Enhanced Expressions
      • Enhanced Condition
      • New or Enhanced Functions
    • PL/SQL
      • ACCESSIBLE BY clause Enhancements
      • Data-Bound Collation
      • PL/SQL Expressions Enhancements
      • Support for SQL JSON operators in PL/SQL (based on SQL changes)
      • PL/SQL Coverage Pragma
      • PL/SQL Deprecation Pragma
      • Sharing Metadata-Linked Application Common Objects
• Changed:
  • Requires at least a Java 7 runtime environment
• Fixed:
  • Parsing errors in XMLELEMENT and other functions when using certain non-standard function parameters

PL/SQL Analyzer v1.1.1

• Released on 2017-02-05
• Improved:
  • JDK detection
• Fixed:
  • single_table_insert with values_clause leads to parse errors in SQL scripts if terminated by slash instead of semicolon
  • greater equal (>=) and less equal (<=) are reported as less than (<)

PL/SQL Analyzer v1.0.13

• Released on 2016-12-16
• Extended grammar to support additional keyword PERIOD, e.g. as variable name
• Extended grammar to support keywords as measure_column of a cell_assignment in the model_clause

PL/SQL Analyzer v1.0.12

• Released on 2016-09-05
• Fixed grammar to support inline views as target of a MERGE statement (undocumented)
• Fixed grammar to support ASC|DESC and NULLS FIRST|LAST in row_pattern_order_by clause (undocumented)
• Updated PLSQL.xsd and HTML documentation

PL/SQL Analyzer v1.0.11

• Released on 2016-08-26
• Fixed grammar to support default namespace at any position within XMLnamespaces_clause
• Fixed grammar to support Temporal Validity in flashback_query_clause
• Fixed grammar to support VARCHAR with BYTE and CHAR semantics (as VARCHAR2)
• Extended grammar to support multiple flashback_query_clause
• Extended grammar to support ~ as quote delimiter character
• Extended grammar to support additional keywords, e.g. as variable name
  • body
  • show
  • subtype
  • versions