implications of quoted_identifier in SQL

Question

Hi Friends What are the implications of quoted_identifier in SQL ?

Vulpes · Answer

Quoted identifiers (i.e. identifiers surrrounded by double quotes) enable you to use names for identifiers which would otherwise be illegal such as reserved words or names which contain embedded spaces. However if you use them then string literals must be enclosed in single quotes to distinguish them from quoted identifiers.