G-2185: Avoid using overly short names for explicitly or implicitly declared identifiers.
Minor
Maintainability
Reason
You should ensure that the name you have chosen well defines its purpose and usage. While you can save a few keystrokes typing very short names, the resulting code is obscure and hard for anyone besides the author to understand.
Example (bad)
1 2 3 4 5 6 7 8 9 10 11 | declare i integer; c constant integer := 1; e exception; begin i := c; exception when e then null; end; / |
Example (good)
1 2 3 4 5 6 7 8 9 10 11 | declare l_sal_comm integer; k_my_constant constant integer := 1; e_my_exception exception; begin l_sal_comm := k_my_constant; exception when e_my_exception then null; end; / |