Input Parameters

An input parameter can be either a named parameter or a positional parameter.

• A named input parameter is designated by a colon (:) followed by a string; for example, :name.

• A positional input parameter is designated by a question mark (?) followed by an integer. For example, the first input parameter is ?1, the second is ?2, and so forth.

The following rules apply to input parameters.

• They can be used only in a WHERE or HAVING clause.

• Positional parameters must be numbered, starting with the integer 1.

• Named parameters and positional parameters may not be mixed in a single query.

• Named parameters are case-sensitive.