「Oracle」パッケージ(package)の存在を確認する方法

2014年11月19日2021年8月30日

パッケージの存在確認　使用例1

SELECT

FROM

ALL_OBJECTS

WHERE

OBJECT_TYPE = 'PACKAGE'

AND OWNER = 'user003';

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE' AND OWNER = 'user003';

SELECT
  * 
FROM
  ALL_OBJECTS 
WHERE
  OBJECT_TYPE = 'PACKAGE' 
  AND OWNER = 'user003';

パッケージのボディ　使用例2

SELECT

FROM

ALL_OBJECTS

WHERE

OBJECT_TYPE = 'PACKAGE BODY'

AND OWNER = 'user004';

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE BODY' AND OWNER = 'user004';

SELECT
  * 
FROM
  ALL_OBJECTS 
WHERE
  OBJECT_TYPE = 'PACKAGE BODY' 
  AND OWNER = 'user004';

Posted by arkgame