Plsql Formatter Settings Versions Save

PL/SQL & SQL formatter settings based on the Trivadis PL/SQL & SQL Coding Guidelines

sqldev-21.4.0

2 years ago

Formatter Settings for SQLDev 21.4.0

Settings for

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 8, 11, 17.

See main branch for settings supporting the latest product versions.

New

  • #168 Settings are compatible with SQLcl 21.4.0 and SQLDev 21.4.0

Fixed

  • #149 Wrong formatter result when using spool command
  • #150 Line break in define command
  • #167 Consider leading/trailing commas when adding line breaks between parameters
  • #172 Standalone tvdformat crashes when using config.json

sqlcl-21.3.3

2 years ago

Formatter Settings for SQLcl 21.3.3

Settings for

See main branch for settings supporting the latest product versions.

New

  • #154 Accept directories in the file list of the json configuration file (format.js, tvdformat.jar)
  • #160 Keep short null condition on same line
  • #162 Add capability to exclude files from formatting (format.js, tvdformat.jar)
  • #164 Enforce concise line separator logic (either LF or CRLF)

Fixed

  • #152 Line break before from in extract function
  • #156 Honor ext parameter when processing single file (format.js,tvdformat.jar)
  • #158 Wrong indent for collection item

sqldev-21.2.1

2 years ago

Formatter Settings for SQLDev 21.2.1

Settings for

See main branch for settings supporting the latest product versions.

New

  • #130 Single Arbori file, no need to set dbtools.arbori.home in product.conf anymore
  • #134 Support materialized views
  • #135 Formatter ignores code with syntax errors
  • #137 Improved formatter performance for in r2_increment_left_margin_by_keyword_outside_node
  • #146 Git pre-commit hook example
  • #147 format.js - Ensure that file ends with an OS specific line separator

Fixed

  • #129 Line break after IN for IN OUT parameters
  • #133 Formatter removes all whitespace and produces invalid code
  • #139 Changing formatter results when using multiple XMLTABLE functions
  • #145 format.js - file extension parameters are not honored when processing JSON file array

sqldev-21.2.0

2 years ago

Formatter Settings for SQLDev 21.2.0

Settings for

See main branch for settings supporting the latest product versions.

New

  • #119 Standalone formatter tvdformat.jar
  • #126 Format view column list

Fixed

  • #114 White Space: After comma (unchecked) is honored for leading commas only
  • #121 IndexOutOfBoundsException when formatting code ends on comment
  • #123 Broken code after calling formatter (undefined instead of whitespace)

sqlcl-21.1.0-light

2 years ago

Formatter Settings for SQLcl 21.1.0-light

Settings for

See main branch for settings supporting the latest product versions.

New

  • #81 Improve result of parenthesis in where clause
  • #97 Align embedded settings in format.js with trivadis_advanced_format.xml
  • #99 No line break before left parenthesis of a procedure definition
  • #105 Initial release based on the lightweight formatter (see also this blog post)

sqlcl-21.1.0

2 years ago

Formatter Settings for SQLcl 21.1.0

Settings for

See main branch for settings supporting the latest product versions.

Last version based on the adapted Arbori program provided by the SQLDev team. Future version will be based on the lightweight formatter, which uses an Arbori program that is written from scratch (see #105)3.

Fixed

  • #106 format.js - Cannot process RootPath with spaces
  • #109 Bad performance of splitArg query

sqldev-20.4.1

3 years ago

Formatter Settings for SQLDev 20.4.1

Settings for

See main branch for settings supporting the latest product versions.

sqlcl-20.3.0

3 years ago

Formatter Settings for SQLcl 20.3.0

Settings for

See main branch for settings supporting the latest product versions.

sqldev-20.2.0

3 years ago

Formatter Settings for SQLDev 20.2.0

Settings for

  • Oracle SQLcl, Version 20.2.0
  • Oracle SQL Developer, Version 20.2.0
  • Allround Automations PL/SQL Developer, Version 13.0.6

See main branch for settings supporting the latest product versions.

sqldev-19.4.0

3 years ago

Formatter Settings for SQLDev 19.4.0

Settings for

  • Oracle SQLcl, Version 19.4.0
  • Oracle SQL Developer, Version 19.4.0
  • Allround Automations PL/SQL Developer, Version 13.0.6

See main branch for settings supporting the latest product versions.