For a stored procedure to write a large number of SQL statements, which inevitably need to beautify the statement, making the program more readable.
The PL/SQL Developer development tool comes with a beautification tool, but it's easy to make the statement all the way to uppercase when it's beautiful, so you need a plug-in package or a package that allows the program to format without changing the original case.
1, self-brought landscaping, (not perfect, not recommended recommended use)
2. Place the sqlbeautifier.br file under the root directory of the PL/SQL Developer tool installation (recommended)
3. In the Open PL/SQL developer Tool "preferences", select File configuration
4. Restart PL/SQL Developer Development Tools
5, write SQL statements, especially write a large number of stored procedure statements, after writing, click the Beautify button.
After the beautification of the statement is not very readable:
Download package: https://download.csdn.net/download/u011062867/9824610
Beautifier beautification plugin for PL/SQL Developer Development Tools