SQLcl 23.4.0

Formatter Settings for SQLcl 23.4.0

Settings for

• Oracle SQLcl, Version 23.4.0
• Oracle SQL Developer, Version 23.1.1.345 (requires dbtools-common.jar from SQLcl 23.4.0 using ParseNode.class from SQL Developer 23.1.1.345)

These settings have been defined and tested with the product versions mentioned above. They might not work in other versions.

Please note, that these settings cannot be used in Oracle SQL Developer for VSCode 23.4.0. And it does not work in the embedded version of SQLcl 23.3.1.0, which cannot run JavaScript.

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar requires JDK 17 or newer (due to the latest JavaScript engine).

See Patching SQL Developer for background information and instructions.

New

• #269 Support SQLcl 23.4.0
  • The new parser can deal with stored Java procedures (it does not report syntax errors anymore).
  • If we detect Java procedures we disable the process to convert quoted identifiers to unquoted identifiers to ensure we don't treat Javas strings as quoted identifiers and break the code. As a result, files and buffers containing Java procedures are now formatted.
  • Native images are not part of a release. You have to build them yourself as described here. This works again since SQLcl removed the use of GUI components in the relevant code path (which is BTW the reason we need to include the old ParseNode.class to ensure that the "Code Outline" continues to work in SQLDev).

Fixed

• #264 Unwanted line break after whenever oserror breaks code
• #265 Wrong indentation in subqueries of insert statements
• #266 Unwanted line break before on conversion error in subquery
• #267 Untwanted formatting of out-of-scope statements such as grant

See main branch for the latest version.

SQLcl 23.3.0

Formatter Settings for SQLcl 23.3.0

Settings for

• Oracle SQLcl, Version 23.3.0
• Oracle SQL Developer, Version 23.1.1 (requires dbtools-common.jar from SQLcl 23.3.0)

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

See Patching SQL Developer for background information and instructions.

New

• #260 Support SQLcl 23.3.0
• #262 Do not reset Arbori program when importing trivadis_advanced_format.xml

See main branch for the latest version.

SQLDev 23.1.0

Formatter Settings for SQLDev 23.1.0

Settings are primarily provided for

• Oracle SQLcl, Version 23.1.0
• Oracle SQL Developer, Version 23.1.0

These settings have been defined and tested with the product versions mentioned above. They might not work in other versions.

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

New

• #251 Support SQL Developer 23.1.0 and SQLcl 23.1.0 that including grammar for Oracle Database 23c

Fixed

• #249 Constants and variables in package specifications are not aligned

See main branch for the latest version.

SQLcl 22.4.0

Formatter Settings for SQLcl 22.4.0

Settings for

• Oracle SQLcl, Version 22.4.0
• Oracle SQL Developer, Version 22.2.1 (requires dbtools-common.jar from SQLcl 22.4.0, however, this breaks the code completion feature)

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

New

• #244 New timeout parameter in standalone formatter. The parameter defines the time in seconds to wait for the completion of the formatting for a file. The parameter is not applicable within SQLcl.

Fixed

• #243 Runtime failure when formatting single file with ignore option

See main branch for the latest version.

SQLcl 22.3.0

Formatter Settings for SQLcl 22.3.0

Settings for

• Oracle SQLcl, Version 22.3.0
• Oracle SQL Developer, Version 22.2.1 (requires dbtools-common.jar from SQLcl 22.3.0, however, this breaks the code completion feature)

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

New

• #238 Remove quoted identifiers
• #240 Update settings to make them compatible with SQLcl 22.3.0

Fixed

• #232 Stop of SQL code blocks in Markdown files is identified wrongly
• #234 Building native image on Windows 11 - mvn failure

See main branch for the latest version.

SQLcl 22.2.1

Formatter Settings for SQLcl 22.2.1

Settings for

• Oracle SQLcl, Version 22.2.1
• Oracle SQL Developer, Version 22.2.0

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

New

• #211 Document scope of the formatter (which statements are formatted and which are kept "as is")
• #226 Update to GraalVM 22.2.0 (Native Image)
• #228 Guessing the character set of the file to be formatted (format.js, tvdformat)
• #229 Do not suppress errors in SQL code blocks within Markdown files (format.js, tvdformat)

Fixed

• #214 Line breaks in values_clause of insert statement lost
• #216 Indentation in case expression of create table statement lost
• #218 Missing indentation of column aliases within subquery factory clause
• #220 Wrong indentation of comment before first when keyword in case expression
• #223 Warning on empty staging area: Bypassing formatter due to partial commit (Git pre-commit hook)

See main branch for the latest version.

SQLDev 22.2.0

Formatter Settings for SQLDev 22.2.0

Settings for

• Oracle SQLcl, Version 22.2.0
• Oracle SQL Developer, Version 22.2.0

JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.

New

• #208 Update formatter settings for SQLDev 22.2.0 and SQLcl 22.2.0

Fixed

• #192 Cannot build standalone formatter with "OpenJDK 64-Bit Server VM GraalVM CE 22.0.0.2 (build 17.0.2+8-jvmci-22.0-b05)"
• #203 Wrong indentation of case expression in right-aligned clause
• #204 Lost line break after label
• #205 Lost space after equal sign
• #210 Missing indentation of subquery in insert statement

See main branch for the latest version.

SQLDev 21.4.3

Formatter Settings for SQLDev 21.4.3

Settings for

• Oracle SQLcl, Version 21.4.1
• Oracle SQL Developer, Version 21.4.3

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

New

• #193 Make exclusion list OS independent

Fixed

• #196 Unwanted spaces in negative number literal after sign
• #197 Wrong indentation in case when expression with single line comments
• #198 Missing indentation in subsequent lines of return statement

See main branch for the latest version.

SQLDev 21.4.2

Formatter Settings for SQLDev 21.4.2

Settings for

• Oracle SQLcl, Version 21.4.1
• Oracle SQL Developer, Version 21.4.2

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

New

• #179 Add version number to format.js and trivadis_custom_format.arbori
• #181 Reduce size of executable JAR and native image
• #182 format.js - make logging configuration available in the JavaScript

Fixed

• #186 indention of PL/SQL definitions in WITH clause
• #188 Remove line break after update keyword if breakAfterSelect = false
• #189 Indent private PL/SQL definition in method of type body

See main branch for the latest version.

SQLDev 21.4.1

Formatter Settings for SQLDev 21.4.1

Settings for

• Oracle SQLcl, Version 21.4.0
• Oracle SQL Developer, Version 21.4.1

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

• #118 Improved Formatter based on tests for PL/SQL language elements

  • add space after raise keyword and before exception name
  • no spaces before arguments of pragma references
  • enforce one space after return keyword and before expression in return statement
  • right align bulk keyword in delete statement
  • one space after returning keyword
  • one space before collect keyword in bulk collect
  • single space around equal sign in sharing_clause
  • one space after while keyword in while loop statement

• #175 Merge tests project into standalone project

• #177 Improve logging capabilities of standalone image and native image creation

  • Configure logging via environment variables (standalone tvdformat):
    • TVDFORMAT_LOGGING_CONF_FILE
    • TVDFORMAT_DEBUG
    • TVDFORMAT_TIMING
  • Support --no-fallback native image
    • works with default Arbori program
    • works with trivadis_custom_format.arbori