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 | Quoted identifier "sal+comm". |
| 3 | 4 | Quoted identifier "my constant". |
| 4 | 4 | Quoted identifier "my exception". |
| 6 | 4 | Quoted identifier "sal+comm". |
| 6 | 18 | Quoted identifier "my constant". |
| 7 | 17 | Quoted identifier "sal+comm". |
| 9 | 9 | Quoted identifier "my exception". |
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 list 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