Using Formatter Plus for PLSQL


Using Formatter Plus for PL/SQL

Formatter Plus for PL/SQL, now included with TOAD Standard Edition, provides expert code formatting, syntax checking, reviews, code profiling, and best practice recommendations. However, many TOAD users barely scratch the surface of this tool's functionality. TOAD users generally locate and utilize the code formatting capabilities offered within TOAD's PL/SQL Editor as shown in Figure 10.1. With a simple context menu selection, the selected code is consistently and expertly formatted.

Figure 10.1. TOAD PL/SQL Editor ”Format Code.

But by merely choosing the last menu option to launch Formatter Plus for PL/SQL instead, a whole plethora of features becomes available. You can do any of the following:

  • Define detailed, customized Formatter options, as shown in Figure 10.2. Now Formatter Plus for PL/SQL works the way you want. Define a set of shared corporate standards, and all your PL/SQL code can be formatted to that standard.

    Figure 10.2. Formatter Plus ”Formatter Options.

  • Perform an expert PL/SQL review for code correctness, maintainability, efficiency, readability, and program structure as shown in Figure 10.3. With just the click of a button, you now have the same benefits as if you had performed a code walk-through with a room full of PL/SQL experts.

    Figure 10.3. Formatter Plus ”PL/SQL Code Review.

  • Perform an expert PL/SQL analysis for each and every programmatic construct, with expert commentary regarding Oracle version dependencies, as shown in Figure 10.4. With just the click of a button, you now have a detailed summarization of the PL/SQL coding techniques used.

    Figure 10.4. Formatter Plus ”PL/SQL code analysis.



TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net