Oracle PL/SQL - Neglecting Double Quotation Marks

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Introduction
  4. Quoted User-Defined Identifiers

Introduction

The following code references a quoted user-defined identifier that is a reserved word.

Demo

SQL>
SQL> DECLARE-- from  www  .ja  va  2  s.  c om
  2   "MYNAME" varchar2(10) := 'myname';  -- MYNAME is not a reserved word
  3   "BEGIN" varchar2(10) := 'begin';  -- BEGIN is a reserved word
  4  BEGIN
  5   DBMS_Output.Put_Line(Hello);      -- Double quotation marks are optional
  6   DBMS_Output.Put_Line("BEGIN");    -- Double quotation marks are required
  7  end;
  8  /
myname
begin

PL/SQL procedure successfully completed.

SQL>

Related Topic