Oracle PL/SQL - Quoted User-Defined Identifiers

Introduction

A quoted user-defined identifier is enclosed in double quotation marks.

Between the double quotation marks, any characters from the database character set are allowed except

  • double quotation marks,
  • new line characters, and
  • null characters.

For example, these identifiers are acceptable:

"X+Y+Z"              
"first name" 
"on/off" 
"student(s)" 
"*** title ***"
"TABLE"   --reserve word

The quoted identifier cannot exceed 30 bytes excluding the double quotation marks.

A quoted user-defined identifier is case-sensitive.

If a quoted identifier without quotation is a valid identifier, then the quotation marks are optional in references to the identifier. Then reference to it is case-insensitive.

Related Topics