MariaDB [test]> set sql_mode='oracle';

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> 

MariaDB [test]> CREATE TABLE persons(

    ->     person_id NUMBER GENERATED BY DEFAULT AS IDENTITY,

    ->     first_name VARCHAR2(50) NOT NULL,

    ->     last_name VARCHAR2(50) NOT NULL,

    ->     PRIMARY KEY(person_id)

    -> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the rig

ht syntax to use near 'BY DEFAULT AS IDENTITY,    first_name VARCHAR2(50) NOT NULL,

    last_name V...' at line 2

MariaDB [test]> 

MariaDB [test]> select @@version,@@version_comment;

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

| @@version          | @@version_comment |

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

| 11.4.3-MariaDB-log | MariaDB Server    |

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

1 row in set (0.000 sec)