Defining the Indefinable: NULL : Variable Declare « PL SQL « Oracle PL / SQL






Defining the Indefinable: NULL

 
SQL>
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  end;
  9  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>

 








Related examples in the same category

1.Declare variable as a loop counter
2.Variables and Constants
3.Raise the VALUE_ERROR exception
4.Raise the 'no data found' exception
5.Declare variables which will be used in SQL statements