Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Character and string literals in the Oracle world are enclosed by single quotes

SQL> SQL> declare   2      v_char  CHAR(1):='H';   3      v_text1 VARCHAR2(10) :='Hello';   4      v_text2    CHAR(1) :=''; -- the same as NULL   5  begin   6     NULL;   7  End;   8  / PL/SQL procedure successfully completed. SQL>