Command-line interface for SQL formatting

As an alternative to using the SQL Developer graphical interface for formatting, put an .sql file or all .sql files in a directory or folder.

Before invoking the command-line interface for SQL formatting, start the SQL Developer graphical interface so that the database, that is SQL Formatter preferences (which are used for the formatting), is loaded and available.

The following example takes the SQL code in C:\Performance_Issues\MyScript.sql and creates C:\Performance_Issues\MyScript_Out.sql containing the formatted code. (Enter the command in one command line.):

C:\sqldeveloper\sqldeveloper\bin>sdcli format input= C:\Performance_Issues\MyScript.sql output= C:\Performance_Issues\MyScript_Out.sql