可以到PL/SQL的Packages里面去看 或者 select * from sys.user_source
pl sql developer, 打包名, 再加个点, 函数就自动列出来了~
SELECT t1.PROCEDURE$ as PROCEDURE, T1.PLS_TYPE, to_char(T1.POSITION#) POSITION, t1.ARGUMENT, to_char(t1.IN_OUT) IN_OUT FROM SYS.ARGUMENT$ t1, sys.all_objects t2 WHERE t1.OBJ#=t2.OBJECT_ID and t1.PROCEDURE$='FUNCTION_NAME' and t2.OWNER= 'USER_NAME' and t2.OBJECT_NAME='PACKAGE_NAME' order by t1.POSITION#
或者
select * from sys.user_source
打包名, 再加个点, 函数就自动列出来了~
T1.PLS_TYPE,
to_char(T1.POSITION#) POSITION,
t1.ARGUMENT,
to_char(t1.IN_OUT) IN_OUT
FROM SYS.ARGUMENT$ t1,
sys.all_objects t2
WHERE t1.OBJ#=t2.OBJECT_ID
and t1.PROCEDURE$='FUNCTION_NAME'
and t2.OWNER= 'USER_NAME'
and t2.OBJECT_NAME='PACKAGE_NAME'
order by t1.POSITION#