1.

What is JDBC SQL escape syntax?

Answer»

The escape syntax gives you the flexibility to use database specific features unavailable to you by using standard JDBC methods and properties.

The general SQL escape syntax format is as follows

{keyword 'parameters'}.

JDBC defines escape sequences that contain the standard syntax for the following language features

  • Date, time, and timestamp literals (d, t, ts Keywords).

  • Scalar functions such as numeric, string, and data type conversion functions(fn Keyword).

  • Outer joins(oj Keyword)

  • Escape characters for wildcards used in LIKE clauses(escape Keyword).

  • Procedure calls(call Keyword).



Discussion

No Comment Found