상세 컨텐츠

본문 제목

오라클패키지 프로시저 확인

DataBase/Oracle

by 탑~! 2013. 7. 24. 10:37

본문

 -- 패키지.프로시저 내용
SELECT ARGUMENT_NAME,DATA_TYPE,IN_OUT,SEQUENCE FROM all_arguments
WHERE object_id =
(SELECT object_id FROM all_objects WHERE owner = 'owner명'
AND object_name ='패키지명'
AND object_type ='PACKAGE')
AND OBJECT_NAME='프로시저명'
ORDER BY Object_Name, Overload, Sequence

-- 프로시저 내용
SELECT ARGUMENT_NAME,DATA_TYPE,IN_OUT,SEQUENCE FROM all_arguments
WHERE object_id =
(SELECT object_id FROM all_objects WHERE owner = 'owner명'
AND object_name ='프로시저명'
AND object_type ='PROCEDURE')
ORDER BY Object_Name, Overload, Sequence


관련글 더보기