Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Assigning an empty string to the character variable is exactly the same as assigning NULL to it

SQL> SQL> declare   2       v_text CHAR(1) :=''; -- the same as NULL   3  begin   4     NULL;   5  End;   6  / PL/SQL procedure successfully completed. SQL>