On Oracle-based code, the code quality checking feature provides suggestions regarding improved code on a statement-by-statement basis. As you work in SQL Editor, markers provide annotations that prevent and fix common mistakes in the code.
Notes regarding code quality suggestions appear in a window on any line of code where the editor detects an error, or otherwise detects that the code may not be as efficient as it might be. Code quality check annotations are activated by clicking the light bulb icon in the margin, or by selecting Ctrl + l on your keyboard.
The following common errors are detected by the code quality check function in the editor:
- Statement is missing valid JOIN criteria
- Invalid or missing outer join operator
- Transitivity issues
- Nested query in WHERE clause
- Wrong place for conditions in a HAVING clause
- Index suppressed by a function or an arithmetic operator
- Mismatched or incompatible column types
- Null column comparison
To activate code quality checks
- Click the light bulb icon in the margin of the editor or select Ctrl + l on your keyboard. The editor suggestions appear in a window beneath the selected statement. When you click a suggested amendment, the affected code is automatically updated.