Re: Oracle該如何查詢一Pakage底下Funs/Procs的數量

[TeemingVoid (TeemingVoid)]

※ 引述《Hikki520 (Hirayama...............)》之銘言：
: 各位DB板的大大好:
: 想請教各位是否知道在Oracle中如何計算一Pakage底下有的
: Procedures / Functions的名稱or數量
: m(_ _)m 煩請不吝告知，感謝。

舉例來說，如果有個 Package 叫 FINANCE:

CREATE PACKAGE Finance AS  -- package specification
   FUNCTION Compound
         (Years  IN NUMBER,
          Amount IN NUMBER,
          Rate   IN NUMBER) RETURN NUMBER;
   PRAGMA RESTRICT_REFERENCES (Compound, WNDS, WNPS, RNDS, RNPS);
END Finance;

CREATE PACKAGE BODY Finance AS  --package body
   FUNCTION Compound
         (Years  IN NUMBER,
          Amount IN NUMBER,
          Rate   IN NUMBER) RETURN NUMBER IS
   BEGIN
      RETURN Amount * POWER((Rate / 100) + 1, Years);
   END Compound;
END Finance;
/

上述程式採自 Oracle 參考手冊。

接下來，想列出 Package Body 的內容清單可以這麼做:

select distinct
  p.object_name AS package_name,
  p.procedure_name
from all_procedures p join all_objects o
   on (o.object_name = p.object_name
       and o.object_type = 'PACKAGE')
where p.object_name = 'FINANCE';

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 111.252.125.215
推 Hikki520:高手大大感謝您!!!!!!!!!!!!