http://www.itpub.net/thread-1499223-20-1.html
197楼
我在当前会话把PL/Scope打开：
ALTER SESSION SET plscope_settings='identifiers:all' /
然后我创建了这个包头：
CREATE OR REPLACE PACKAGE plch_pkg IS PROCEDURE do_stuff; END plch_pkg; /
下列哪些查询实现了一个包体，从而使得下列的查询：
SELECT name, usage
FROM user_identifiers
WHERE object_name = 'PLCH_PKG'
AND type IN ('PROCEDURE', 'FUNCTION')
ORDER BY usage
/
会输出这些结果：
NAME USAGE ---------- ----------- DO_STUFF CALL DO_STUFF DECLARATION DO_STUFF DECLARATION DO_STUFF DEFINITION DO_STUFF DEFINITION
(A)
CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE do_stuff (number_in IN NUMBER) IS BEGIN NULL; END do_stuff; PROCEDURE do_stuff IS BEGIN NULL; END do_stuff; END plch_pkg; /
SQL> SELECT name, usage
2 FROM user_identifiers
3 WHERE object_name = 'PLCH_PKG'
4 AND type IN ('PROCEDURE', 'FUNCTION')
5 ORDER BY usage
6 /
NAME USAGE
-------------------------------------------------------------------------------- -----------
DO_STUFF DECLARATION
DO_STUFF DECLARATION
DO_STUFF DEFINITION
DO_STUFF DEFINITION
SQL>
(B)
CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE do_stuff IS BEGIN NULL; END do_stuff; END plch_pkg; /
SQL>
SQL> SELECT name, usage
2 FROM user_identifiers
3 WHERE object_name = 'PLCH_PKG'
4 AND type IN ('PROCEDURE', 'FUNCTION')
5 ORDER BY usage
6 /
NAME USAGE
-------------------------------------------------------------------------------- -----------
DO_STUFF DECLARATION
DO_STUFF DEFINITION
SQL>
(C)
CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE do_stuff (number_in IN NUMBER) IS BEGIN NULL; END do_stuff; PROCEDURE do_stuff IS BEGIN do_stuff (1); END do_stuff; END plch_pkg; /
SQL> SELECT name, usage
2 FROM user_identifiers
3 WHERE object_name = 'PLCH_PKG'
4 AND type IN ('PROCEDURE', 'FUNCTION')
5 ORDER BY usage
6 /
NAME USAGE
-------------------------------------------------------------------------------- -----------
DO_STUFF CALL
DO_STUFF DECLARATION
DO_STUFF DECLARATION
DO_STUFF DEFINITION
DO_STUFF DEFINITION
SQL>
(D)
CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE do_stuff (number_in IN NUMBER) IS BEGIN NULL; END do_stuff; PROCEDURE do_stuff IS BEGIN NULL; END do_stuff; BEGIN do_stuff (1); END plch_pkg; /
SQL> SELECT name, usage
2 FROM user_identifiers
3 WHERE object_name = 'PLCH_PKG'
4 AND type IN ('PROCEDURE', 'FUNCTION')
5 ORDER BY usage
6 /
NAME USAGE
-------------------------------------------------------------------------------- -----------
DO_STUFF CALL
DO_STUFF DECLARATION
DO_STUFF DECLARATION
DO_STUFF DEFINITION
DO_STUFF DEFINITION
SQL>
答案说明在202楼
2011-11-29 答案CD
A:在此选项中do_stuff被重载，所以DECLARATION 和 DEFINITION的显示行数是正确的。但是，并没有对do_stuff的调用。
B:为了使得DECLARATION 和 DEFINITION各显示两行，do_stuff必须被重载。
C:既有重载又有调用，正确。
D:同上，只是调用的地方不同。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/680385/viewspace-2669565/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
2011-11-28 取单行数据
下一篇：
2011-11-30 一致读
请登录后发表评论
登录
全部评论
