This software allows you to tidy, beautify or format your Pl/Sql code in a Batch file or Dos prompt.
In other words, it is a command line tool that can be built in your programming environment. It can be used in most free or commercial editors/IDEs.
It also contains a tool Experimenter which provides an alternative user interface to the formatter. In this way, the command line switches of the formatter can be tried out/determined quickly and easily.
programming environment. It can be used in most free or commercial editors/IDEs.
It also contains a tool Experimenter which provides an alternative user interface to the formatter. In this way, the command line switches of the formatter can be tried out/determined quickly and easily.
Features:
-formats sqlplus scripts, Pl/Sql and Sql
-indents Pl/Sql depending on block level
-quantity of indent can be specified for each block level independently
-uppercase,lowercase or capitalized keywords/identifiers
-indention with spaces or tabs or tabs and spaces
-clipboard can be used as a source and destination of the formatting
-slightly Compact code (removal of redundant space)
-very compact code (all padding spaces are removed e.g. around operations +-)
-formats lists in brackets
-aligns assigntments vertically
-wrapping
-simple syntax checking
-backs up original code and keeps old versions of code
-and many others. (there are more than 90 switches).
Changes
2.5.1.1(4.8.2010)
-fixed: print usage message
-fixed: new lines were omitted html output in long multiline quotes and other cases
-fixed: potential infinite loops
-fixed: number token (scientific notation)
-improved: better unclosed error messages
-fixed: somewhat incorrect error message if the formatter fails internally
-improved: the pair not found error message