The PREPARE statement prepares the SQL statement and calls it S1. The EXECUTE statement executes S1 repeatedly, using different values for EMP. Using more than one parameter marker The prepared statement (S1 in the example) can contain more than one parameter marker. If it does, the ...