Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
The single quote character is used extensively in Oracle SQL syntax to delimit strings.
Double quotes are occasionally used in SQL*Plus. They are necessary in column names and headers that contain spaces. For example, the only way to name a column in a CREATE TABLE command as "My Column" is by enclosing it in double quotes.