【Oracle】オブジェクト情報抽出(プロシージャー、ファンクション)
オブジェクト一覧
SELECT OBJECT_NAME ,PROCEDURE_NAME ,OBJECT_TYPE ,AGGREGATE ,PIPELINED ,PARALLEL ,INTERFACE ,DETERMINISTIC ,AUTHID FROM USER_PROCEDURES --WHERE OBJECT_NAME IN ('TEST') ORDER BY OBJECT_NAME,PROCEDURE_NAME
オブジェクト引数一覧
SELECT PACKAGE_NAME ,OBJECT_NAME ,POSITION ,ARGUMENT_NAME ,DATA_TYPE ,DEFAULTED ,DEFAULT_VALUE ,DEFAULT_LENGTH ,IN_OUT ,DATA_LENGTH ,CHARACTER_SET_NAME ,TYPE_NAME ,TYPE_SUBNAME FROM USER_ARGUMENTS WHERE --OBJECT_NAME IN ('TEST') AND DATA_LEVEL <= 1 AND POSITION > 0 order by PACKAGE_NAME,object_name,overload,DATA_LEVEL,position
両方ともオブジェクトが多いときは、名前とかで絞り込むといい。