Oracle PL/SQL/System Tables Views/all arguments

Query all_arguments table

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