读书人

package里头的procedure和function的信

发布时间: 2013-02-19 11:11:40 作者: rapoo

package里面的procedure和function的信息保存在哪个数据字典表里面
package里面的procedure和function的信息保存在哪个数据字典表里面
[解决办法]


SELECT * FROM all_arguments
WHERE object_name LIKE 'MW711%';
OWNER OBJECT_NAME PACKAGE_NAMEOBJECT_IDOVERLOADSUBPROGRAM_IDARGUMENT_NAME
-------------------------------------------------------------------------------------------------------
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_LIEFERRUECKSTAND_BIS_DATUM
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_GEBI_NR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_VAR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_ART_NR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 (Null)
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 KZ_DRUCK
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 ANZ_GEBI_VAR_BEST_MAX
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 LIEFERORT_ID
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 UR6_SRT

读书人网 >oracle

热点推荐