Oracle-style packages were introduced in MariaDB 10.3.5.
SHOW CREATE PACKAGE [ db_name . ] package_name
The SHOW CREATE PACKAGE
statement can be used when Oracle SQL_MODE is set.
Shows the CREATE
statement that creates the given package specification.
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-create-package/