MySQL、Oracle、DM8、DB2、SQLServer中查询存储过程结构的语句

MySQL

SELECT ROUTINE_DEFINITION AS BODY
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND ROUTINE_SCHEMA = 'TestDB'
AND ROUTINE_NAME = 'LogInsertTrigger';

Oracle

SELECT DBMS_METADATA.GET_DDL('PROCEDURE', 'PRO', 'TEST') AS BODY
FROM DUAL;

DM8

SELECT DBMS_METADATA.GET_DDL('PROCEDURE', 'PRO', 'TEST') AS BODY
FROM DUAL;

DB2

SELECT TEXT AS BODY
FROM SYSCAT.ROUTINES
WHERE ROUTINENAME = 'ADD_NUMBERS'
AND ROUTINESCHEMA = 'TEST_SCHEMA1';

SQLServer

SELECT ROUTINE_DEFINITION AS BODY
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND SPECIFIC_SCHEMA = 'dbo'
AND ROUTINE_NAME = 'sp_MSrepl_startup';