When running with sql_mode=ORACLE, the parser should understand Oracle style placeholders in EXECUTE IMMEDIATE and in PREPARE.
Placeholders are designated as a colon followed by a regular identifier, a delimited identifier, or an integer unsigned number in the range 0..65535:
Placeholders in individual statements are associated by position, not by name. All the above queries insert values 10 and 20 into exactly the same columns of the table t1.
Placeholders can have duplicate names. In this case, every placeholder must have a bind value in the USING clause.
Unlike individual statements, rules in blocks are different. Only each unique placeholder must have an unique value. Blocks are out of scope of this task.