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> --