MariaDB starting with 10.3.5
----------------------------
Oracle-style packages were introduced in MariaDB 10.3.5.

Syntax
------

SHOW CREATE PACKAGE  [ db_name . ] package_name

Description
-----------

The SHOW CREATE PACKAGE statement can be used when Oracle SQL_MODE is set.

Shows the CREATE statement that creates the given package specification.

Examples
--------

SHOW CREATE PACKAGE employee_tools\G
*************************** 1. row ***************************
      Package: employee_tools
      sql_mode:
PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS
NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER
   Create Package: CREATE DEFINER="root"@"localhost" PACKAGE
"employee_tools" AS
 FUNCTION getSalary(eid INT) RETURN DECIMAL(10,2);
 PROCEDURE raiseSalary(eid INT, amount DECIMAL(10,2));
 PROCEDURE raiseSalaryStd(eid INT);
 PROCEDURE hire(ename TEXT, esalary DECIMAL(10,2));
END
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci

URL: https://mariadb.com/kb/en/show-create-package/