Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Represents the old way of placing quotes inside the text, namely to double them

SQL> SQL> declare   2      -- Represents the old way of placing quotes inside the text, namely to double them.   3      v_text1 VARCHAR2(50) :='It''s M''s text.';   4  begin   5      NULL;   6  End;   7  / PL/SQL procedure successfully completed. Text literals in Oracle are case sensitive.