Oracle PL/SQL/System Tables Views/all arguments
Query all_arguments table
<source lang="sql">
SQL> SQL> column object_name format a20 SQL> column data_type format a15 SQL> SQL> clear breaks breaks cleared SQL> break on object_name SQL> SQL> select object_name,
2 argument_name, 3 data_type 4 from all_arguments 5 where owner = "HR" and rownum < 50 6 order by position 7 /
OBJECT_NAME ARGUMENT_NAME DATA_TYPE
------------------------------ ---------------
ADD_JOB_HISTORY P_EMP_ID NUMBER
P_START_DATE DATE P_END_DATE DATE P_JOB_ID VARCHAR2 P_DEPARTMENT_ID NUMBER
5 rows selected. SQL> SQL> --
</source>