G-2180
🆓Warning
Never use quoted identifiers.
Reason
Quoted identifiers make your code hard to read and maintain.
Example
Non-Compliant Example
declare "sal+comm" integer; "my constant" constant integer := 1; "my exception" exception; begin "sal+comm" := "my constant"; do_something("sal+comm"); exception when "my exception" then null; end; /
Issues
Line | Column | Message |
---|---|---|
2 | 4 | |
3 | 4 | |
4 | 4 | |
6 | 4 | |
6 | 18 | |
7 | 17 | |
9 | 9 |
★★★★★
Compliant Solution -
declare l_sal_comm integer; co_my_constant constant integer := 1; e_my_exception exception; begin l_sal_comm := co_my_constant; do_something(l_sal_comm); exception when e_my_exception then null; end; /
Parameters
Use parameters to customize the rule to your needs.
Parameter | Description | Default Value |
---|---|---|
DisableAllQuickFix | Comma-separated ist of rules for which a quick fix should not be applied to all the problems in a file. | Core G-3130 |
References
- same as Trivadis G-2180
- same as plsql:QuotedIdentifiersCheck