- SELECT U.PACKAGE_NAME AS 包名, U.OBJECT_NAME AS 方法
- FROM USER_ARGUMENTS U
- GROUP BY U.OBJECT_NAME, U.PACKAGE_NAME
- ORDER BY U.PACKAGE_NAME, U.OBJECT_NAME;
- SELECT
- U.OBJECT_NAME 方法,
- U.ARGUMENT_NAME 参数,
- U.IN_OUT 参数模式,
- U.DATA_TYPE 参数类型,
- U.POSITION 参数位置
- FROM USER_ARGUMENTS U
- where U.OBJECT_NAME='存储名'
- ORDER BY U.PACKAGE_NAME, U.OBJECT_NAME, U.OVERLOAD, U.SEQUENCE;