...
MySQL : CREATE PROCEDURE <name > ( IN param1 STRING, IN parma2 STRING)
12. CURSOR:
Oracle: CURSOR cursor_name IS select-statement; OPEN cursor_name
MySQL: BEGIN DECLARE my_cursor CURSOR FOR select-statement << can't be prepared statement>>; OPEN my_cursor; END