EXECUTE statement_name [ USING parameter1 [ , parameter2, ... ] ]
statement_name
USING
PREPARE my_select1 FROM SELECT name FROM nation;
EXECUTE my_select1;
PREPARE my_select2 FROM SELECT name FROM nation WHERE regionkey = ? and nationkey < ?;
EXECUTE my_select2 USING 1, 3;
SELECT name FROM nation WHERE regionkey = 1 AND nationkey < 3;
Was this page helpful?