String Literals
Embedded SQL string literals are delimited by single quotes. To embed a single quote in a string literal, precede it with another single quote character, as in:
exec sql insert
into comments (id, val)
values (15, 'This is ''Student'' information');
Because the single quote is the SQL string delimiter, Ada single-character literals are treated like SQL string literals. Embedded SQL/Ada string literals cannot be continued over multiple lines.
Note that the preprocessor does not accept the Ada character string delimiter, the double quote ("). No special characters are required to embed a double quote in an Embedded SQL string literal.