Code Analysis Window
The Code Analysis window provides detailed analysis, including a results dashboard, report, and tree view with violations and code properties. You can also simultaneously analyze multiple files from this window.
|
|
Note: This feature is available in the Professional Edition and higher. |
To perform detailed code analysis
- Click Tools | Code Analysis.
-
Load files or objects to analyze.
Open files. Load objects from the database. You can click the drop-down arrow beside this button to load all objects or choose a group of objects to load.
-
Select the rule set you want to use in the Code Analysis toolbar (the default is Top 20).
-
To evaluate statements' complexity and validity, select Run SQL Scan in the Run Review list on the Code Analysis toolbar.
-
Select the items to analyze in the grid.
Use SHIFT or CTRL to select multiple items.
-
Analyze code for all selected items. Click
or press F9. (Ensure Run Review is selected.)
Alternatively, to apply your selection to all items press F5.
-
Review the Code Analysis results.
Send code back to the Code Editor from the selected file or object. SQL Navigator displays the Code Analysis errors and violations in the tabs below the Code Editor.
Additional details
|
Grid Dashboard |
The right side of the grid displays a dashboard of violations and statistics. The dashboard includes the item's Toad Code Rating (TCR), which is a composite of several rating criteria. The score ranges from 1 (best) to 4 (worst). It provides a quick reference for how your code has performed in the analysis. | ||
|
Result tab |
The Results tab displays the analysis results in a tree view. Expand each node for details on the violations. If you select a violation in the tree view, the preview on the right displays the corresponding code. The Result tab displays the results for the item selected in the grid. If you analyzed multiple items and select them in the grid, the tab displays the results for all of the selected items.
| ||
|
Report tab |
The Reports tab summarizes the analysis results and includes rule definitions. Items in the table of contents are hyperlinked so you can easily navigate the report.
|
in the Code Analysis toolbar to view an icon legend.