Skip to content

G-2140: Never initialize variables with NULL.

Minor

Maintainability

Reason

Variables are initialized to null by default.

Example (bad)

1
2
3
4
5
6
declare
   l_note big_string_type := null;
begin
   sys.dbms_output.put_line(l_note);
end;
/

Example (good)

1
2
3
4
5
6
declare
   l_note big_string_type;
begin
   sys.dbms_output.put_line(l_note);
end;
/