Show TOC

Dynamic Parameter SpecificationLocate 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.

<dynamic parameter specification> ::= '?'

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>.