완성본 아니다...시간나면 좀 더 처리함
SELECT pro.object_type, pro.object_name, arg.argument_name, arg.in_out, arg.data_type
, arg.default_value
, (SELECT
REPLACE(
Upper(REGEXP_REPLACE(src.text, '( ){1,}', '')),
Upper(arg.argument_name||arg.in_out||arg.data_type||':='),
''
) text
FROM User_source src
WHERE (src.text LIKE '% := %' OR Upper(src.text) LIKE '% DEFAULT %')
AND src.name=pro.object_name
AND (text LIKE '% '||arg.in_out||' %')
AND Upper(text) LIKE '% '||arg.argument_name||' %'
) default_value2
FROM User_Procedures pro
, USER_arguments arg
WHERE (pro.object_name) LIKE ('%F_%')
AND arg.object_name = pro.object_name
AND arg.position <> 0
ORDER BY pro.object_type, pro.object_name, arg.position
