rules repository

G-2140

🆓
Warning

Never initialize variables with NULL.

Variable

Rule Details

Severity Level
Minor
Quality Area
Maintainability
Fixing times
1 mins
Local-easy
Database Support
OracleDB (v7.3.4 +)

Reason

Variables are initialized to null by default.

Example

Non-Compliant Example

declare
   l_note big_string_type := null;
begin
   sys.dbms_output.put_line(l_note);
end;
/
Issues
LineColumnMessage
227Unnecessary NULL assignment.

Compliant Solution - ★★★★★

declare
   l_note big_string_type;
begin
   sys.dbms_output.put_line(l_note);
end;
/

References

← Previous
G-2135
Avoid assigning values to local variables that are not used by a subsequent statement.
Next →
G-2145
Never self-assign a variable.