skip to main content
SQL Escape Sequences
 

Try DataDirect Cloud Now

SQL Escape Sequences

JDBC defines escape sequences that contain the standard syntax for the following language features:
*Date, time, and timestamp literals
*Scalar functions such as numeric, string, and data type conversion functions
*Outer joins
*Escape characters for wildcards used in LIKE clauses
*Procedure calls
The escape sequence used by JDBC is:
{extension}
The escape sequence is recognized and parsed by the driver, which replaces the escape sequences with data store-specific grammar.
* Date, Time, and Timestamp Escape Sequences
* Scalar Functions
* Outer Join Escape Sequences
* LIKE Escape Character Sequence for Wildcards
* Procedure Call Escape Sequences