You can declare the whole string to be enclosed in quotes by using the construct q'!text!' : Introduction « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Introduction
SQL>
SQL> declare
  2      
  3      
  4  begin
  5      NULL;
  6  End;
  7  /

PL/SQL procedure successfully completed.


Text literals in Oracle are case sensitive.








21.1.Introduction
21.1.1.Block Structure
21.1.2.Your First PL/SQL Block
21.1.3.The slash character (/) at the end of the example executes the PL/SQL.
21.1.4.You can declare the whole string to be enclosed in quotes by using the construct q'!text!'
21.1.5.All identifiers within the same scope must be unique.
21.1.6.Building Expressions with Operators
21.1.7.PL/SQL datatypes
21.1.8.Variable Naming Rules
21.1.9.Introducing the Main Data type Groups