SQL> set serveroutput on SQL> declare 2 v1 varchar2(10); 3 v2 number; 4 v3 date; 5 str varchar2(30); 6 begin 7 str:=v1||v2||v3; 8 if str is null then 9 dbms_output.put_line('str is null'); 10 end if; 11 end; 12 / str is nullPL/SQL procedure successfully completed
SQL> declare
2 v1 varchar2(10);
3 v2 number;
4 v3 date;
5 str varchar2(30);
6 begin
7 str:=v1||v2||v3;
8 if str is null then
9 dbms_output.put_line('str is null');
10 end if;
11 end;
12 /
str is nullPL/SQL procedure successfully completed