Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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