---------------------+-----------------------------------+

Cursors
-------

Oracle mode makes the following changes to Cursors:

+-----------------------------------------+-----------------------------------+
| Oracle syntax                           | Description                       |
+-----------------------------------------+-----------------------------------+
| CREATE PROCEDURE p1 AS CURSOR cur IS    | Explicit cursor with FOR loop.    |
| (SELECT a, b FROM t1); BEGIN  FOR rec   | MDEV-10581                        |
| IN cur ...                              |                                   |
+-----------------------------------------+-----------------------------------+
| CREATE PROCEDURE p1 AS rec IN (SELECT   | Implicit cursor with FOR loop.    |
| a, b FROM t1)                           | MDEV-12098                        |
+-----------------------------------------+-----------------------------------+
| CURSOR c(prm_a VARCHAR2, prm_b          | Cursor with parameters.           |
| VARCHAR2) ... OPEN c(1,2)               | MDEV-10597                        |
+-----------------------------------------+-----------------------------------+
| CURSOR c(prm_a VARCHAR2, prm_b          | Cursor with parameters and FOR    |
| VARCHAR2) ... FOR rec in c(1,2)         | loop. MDEV-12314                  |
+-----------------------------------------+-----------------------------------+
| s %ISOPEN, %ROWCOUNT, %FOUND, %NOTFOUND | Explicit cursor attributes.       |
|                                         | MDEV-10582                        |
+-----------------------------------------+-----------------------------------+

LOOP
----

Oracle mode makes the following changes to LOOP:

+-----------------------------------------+-----------------------------------+
| Oracle syntax                           | Description                       |
+-----------------------------------------+-----------------------------------+
| FOR i IN 1..10 LOOP ... END LOOP        | Numeric FOR loop. MDEV-10580      |
+-----------------------------------------+-----------------------------------+
| GOTO                                    | GOTO statement.  MDEV-10697       |
+-----------------------------------------+-----------------------------------+
| <<label>> used with GOTO                | ANSI uses label:. MDEV-10697      |
+-----------------------------------------+-----------------------------------+
| To leave loop block: EXIT [ label ] [   | ANSI syntax is IF bool_expr THEN  |
| WHEN bool_expr ]                        | LEAVE label                       |
+-----------------------------------------+-----------------------------------+
| [<<label>>] WHILE boolean_expression    | Oracle style WHILE loop           |
| LOOP statement... END LOOP [ label ] ;  |                                   |
+-----------------------------------------+-----------------------------------+
| CONTINUE [ label ] [ WHEN               | CONTINUE is only valid inside a   |
| boolean_expression]                     | loop                              |
+-----------------------------------------+-----------------------------------+

Variables
---------

+------------------------------+-----------------+--------------------------+
| Oracle syntax                | Version         | Description              |
+------------------------------+-----------------+--------------------------+
| var:= 10; Can also be used   | 10.3            | MariaDB uses SET var=    |
| with MariaDB systemvariables |                 | 10;                      |
+------------------------------+-----------------+--------------------------+
| var INT := 10                | 10.3            | Default variable value   |
+------------------------------+-----------------+--------------------------+
| var1                         | 10.3            | Take data type from a    |
| table_name.column_name%TYPE  |                 | table column. MDEV-10577 |
+------------------------------+-----------------+--------------------------+
| var2 var1%TYPE               | 10.3            | Take data