Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Using Single Quote Characters as Part of Text Strings

SQL> SQL> declare   2         3         4         5      v_text3 VARCHAR2(50) :=q'[It's M's text.]';   6  begin   7      NULL;   8  End;   9  / PL/SQL procedure successfully completed. Text literals in Oracle are case sensitive.