Oracle PL/SQL/System Tables Views/all arguments

Материал из SQL эксперт
Перейти к: навигация, поиск

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>