Reference Guide > TDV SQL Script > SQL Language Concepts > Literal Values
 
Literal Values
A SQL Script can contain any literal value that is valid in SQL, plus type ROW or XML (which need to be defined).
Syntax (ROW-Type Literal Value)
ROW( <valueExpression>, … )
Syntax (XML-Type Literal Value)
There is no literal format for an XML type. Use the following syntax to create an XML type.
CAST ('xml_string' AS XML)
Remarks
The symbols TRUE and FALSE are reserved for use as literal boolean values.
Literal values are delimited by single quotes ('string'). To specify an apostrophe within a string, use two apostrophes in a row ('').
There is no literal format for a cursor type. For details, see DECLARE CURSOR of Type Variable.