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/