Formatting SQL and PL/SQL with a Configurable Formatter

This extension includes a built in and configurable SQL and PL/SQL formatter that you can use to enforce style guidelines on your code.

  • To modify the formatter settings, right click on an Oracle Explorer Connection and select SQL and PL/SQL Formatter Settings. Alternatively, in the SQL editor, click the SQL and PL/SQL Formatter Settings icon.

  • To format SQL or PL/SQL, in the editor, click the Format Document icon, or right click and select Format Document with.. and then select Oracle Developer Tools for VS Code (SQL and PL/SQL)

  • To undo a formatting attempt, use the editor's "Undo" function (Edit->Undo).