Show TOC

Syntax documentationDynamic Parameter Specification Locate this document in the navigation structure

A dynamic parameter specification is used in JDBC in the statement text of a java.sql.PreparedStatement as parameter marker.

Syntax Syntax

  1. <dynamic parameter specification> ::= '?'
End of the code.

Open SQL allows the use of the <dynamic parameter specification>:

  1. as the right side of a comparison,

  2. as the <update source> that is contained in an <update statement>,

  3. as a value in the VALUES clause of an <insert statement>,

  4. as an <in value> in an <in predicate>,

    More information: In predicate

  5. as lower or upper test value in a <between predicate>,

  6. as <pattern> or <escape character> of a <like predicate>.