SELECT ID,
NAME,
ARG_NUM,
IS_INCLUDE_SQL,
CLASS$,
COMMENT$,
NAME || (SELECT'('||LISTAGG(A.NAME ||'=> ', ' , ') WITHINGROUP (ORDERBY SEQ) ||');'FROM V$IFUN_ARG A WHERE A.ID = F.ID AND A.SEQ !=-1) AS CMD
FROM V$IFUN F
WHERE NAME LIKEUPPER('%存储过程名%')
ORDERBY F.ARG_NUM;
SELECT ID, NAME, ARG_NUM, IS_INCLUDE_SQL, CLASS$, COMMENT$, NAME || (SELECT '(' || LISTAGG(A.NAME || '=> ', ' , ') WITHIN GROUP (ORDER BY SEQ) || ');' FROM V$IFUN_ARG A WHERE A.ID = F.ID AND A.SEQ != -1) AS CMD FROM V$IFUN F WHERE NAME LIKE UPPER('%存储过程名%') ORDER BY F.ARG_NUM;