PL/SQL 객체 검색 및 Argument 보기

▣ PL/SQL 객체 검색 및 Argument 보기

뷰 검색 -> 컬럼 리스트 찾기 -> 질의 실행

PL 객체 검색 -> Argument 리스트 찾고 -> 실행

   

S SCOTT> get fp

    select distinct object_name from user_procedures where object_name like '%&KEY%'

S SCOTT> select distinct object_name from user_procedures where object_name like '%&KEY%';

Enter value for key: MYPACK

OBJECT_NAME

------------------------------

MYPACKAGE

S SCOTT> desc MYPACKAGE

PROCEDURE GUGU

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 DAN                            NUMBER                  IN

PROCEDURE PRINT

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 ST                             VARCHAR2                IN

   

   

▣ PL/SQL 객체 검색 및 Argument 보기 - sys 소유, built-in)

S SYS> @fp

Enter value for key: OUTPUT

OBJECT_NAME

------------------------------

DBMS_OUTPUT

DBMS_REPCAT_OUTPUT

S SYS> spool DBMS_OUTPUT    =>   내용이 많으면 확인이 불가능 하므로 spool로 출력 리스트를 저장한다.

S SYS> desc DBMS_OUTPUT

PROCEDURE DISABLE

PROCEDURE ENABLE

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 BUFFER_SIZE                    NUMBER(38)              IN     DEFAULT

PROCEDURE GET_LINE

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 LINE                           VARCHAR2                OUT

 STATUS                         NUMBER(38)              OUT

PROCEDURE GET_LINES

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 LINES                          TABLE OF VARCHAR2(32767) OUT

 NUMLINES                       NUMBER(38)              IN/OUT

PROCEDURE GET_LINES

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 LINES                          DBMSOUTPUT_LINESARRAY   OUT

 NUMLINES                       NUMBER(38)              IN/OUT

PROCEDURE NEW_LINE

PROCEDURE PUT

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 A                              VARCHAR2                IN

PROCEDURE PUT_LINE

 Argument Name                  Type                    In/Out Default?

 ------------------------------ ----------------------- ------ --------

 A                              VARCHAR2                IN

S SYS> spool off

S SYS> ed DBMS_OUTPUT.lst    =>    spool로 저장된 내용 확인

S SYS> exec DBMS_OUTPUT.PUT_LINE('aaa');

aaa

PL/SQL procedure successfully completed.