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

Query OK, 0 rows affected (0.000 sec)

MariaDB [test]> CREATE TABLE "BANANA_FOSTER"

    ->    (    "BANANA_ID" NUMBER(10,0) NOT NULL ENABLE,

    ->     "FOSTER_ID" NUMBER(10,0) NOT NULL ENABLE,

    ->     "DESC" VARCHAR2(100 BYTE) NOT NULL ENABLE,

    ->     "SITE_ID" NUMBER(10,0) NOT NULL ENABLE,

    ->     "CREATION_ID" NUMBER(10,0) NOT NULL ENABLE,

    ->     "CREATION_DATE" TIMESTAMP (6) NOT NULL ENABLE

    ->    )  ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ENABLE,

    "FOSTER_ID" NUMBER(10,0) NOT NULL ENABLE,

    "DESC" VARCHAR2(100 ' at line 2