Assign varaible default value to a varchar variable : Variable Default Value « PL SQL « Oracle PL / SQL






Assign varaible default value to a varchar variable


SQL>
SQL>  declare
  2      value1 varchar2(100);
  3      value2 varchar2(100) := '';
  4      value3 varchar2(100) := null;
  5      value4 varchar2(100) default null;
  6    begin
  7      null;
  8      dbms_output.put_line( value1 );
  9      dbms_output.put_line( value2 );
 10      dbms_output.put_line( value3 );
 11      dbms_output.put_line( value4 );
 12    end;
 13    /

PL/SQL procedure successfully completed.

SQL>
SQL>

           
       








Related examples in the same category

1.Define default value for number variable