skip to main content
Configuring Hybrid Data Pipeline for JDBC : SQL escape sequences
  

Try 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