PL/SQL & SQL formatter settings based on the Trivadis PL/SQL & SQL Coding Guidelines
Settings for
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.
ParseNode.class
to ensure that the "Code Outline" continues to work in SQLDev).whenever oserror
breaks codeinsert
statementson conversion error
in subquerygrant
See main branch for the latest version.
Settings for
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.
See main branch for the latest version.
Settings are primarily provided for
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.
See main branch for the latest version.
Settings for
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.
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.ignore
optionSee main branch for the latest version.
Settings for
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.
See main branch for the latest version.
Settings for
JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.
See main branch for the latest version.
Settings for
JDK 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 11 or newer.
See main branch for the latest version.
Settings for
JDK 8 or 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 8, 11, 17.
See main branch for the latest version.
Settings for
JDK 8 or 11 is required for SQLDev and SQLcl. The standalone tvdformat.jar works with JDK 8, 11, 17.
See main branch for the latest version.
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.
#118 Improved Formatter based on tests for PL/SQL language elements
#175 Merge tests project into standalone project
#177 Improve logging capabilities of standalone image and native image creation
TVDFORMAT_LOGGING_CONF_FILE
TVDFORMAT_DEBUG
TVDFORMAT_TIMING
--no-fallback
native image
trivadis_custom_format.arbori