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.