![]() How Does Formatting Work?įormatting is all about adding (or removing) whitespace (line breaks, spaces or tabs) between significant tokens. If you only want to activate the coding styles suggested by the Trivadis PL/SQL & SQL Coding Guidelines, install the settings as described here. ![]() In this blog post I explain how the formatter works and how the output can be tweaked using two simple SQL queries. And now I must admit that I’m really impressed with the formatting capabilities of the latest versions of SQL Developer. Version 19.2 brought us dynamic JavaScript actions within the parse-tree query language Arbori. In 2017 Oracle released version 4.2 with a new formatter and has been improving it ever since. But the capabilities of the formatter were disappointing. Back then version 4.0 was the latest and greatest.
0 Comments
Leave a Reply. |