Query all_arguments table : all_arguments « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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> --

 

Related examples in the same category