2. Overview of OpenSQL : OpenSQL Features : Regular and Delimited Identifiers
 
Share this page                  
Regular and Delimited Identifiers
Identifiers in OpenSQL statements specify names for the following objects:
User
Column
Correlation name
Cursor
Database procedure
Database procedure parameter
Index
Prepared query
Schema
Table
View
Specify these names using regular (unquoted) identifiers or delimited (double‑quoted) identifiers. For example:
Table name in a select statement specified using a regular identifier:
select * from employees
Table name in a select statement specified using a delimited identifier:
select * from "my table"
Delimited identifiers allow special characters to be embedded in object names. OpenSQL restricts the use of special characters in regular identifiers.