Re: Oracle該如何查詢一Pakage底下Funs/Procs的數量
※ 引述《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
推
01/05 22:48, , 1F
01/05 22:48, 1F
討論串 (同標題文章)
本文引述了以下文章的的內容：
完整討論串 (本文為第 2 之 2 篇)：