2011-11-29 11G新功能：PL/SCOPE

http://www.itpub.net/thread-1499223-20-1.html

197楼

我在当前会话把PL/Scope打开：

ALTER SESSION SET plscope_settings='identifiers:all'/

然后我创建了这个包头：

CREATE OR REPLACE PACKAGE plch_pkgIS   PROCEDURE do_stuff;END plch_pkg;/

下列哪些查询实现了一个包体，从而使得下列的查询：

SELECT name, usage  FROM user_identifiersWHERE     object_name = 'PLCH_PKG'       AND type IN ('PROCEDURE', 'FUNCTION')ORDER BY usage/

会输出这些结果：

NAME       USAGE      ---------- -----------DO_STUFF   CALL      DO_STUFF   DECLARATIONDO_STUFF   DECLARATIONDO_STUFF   DEFINITIONDO_STUFF   DEFINITION

(A)

CREATE OR REPLACE PACKAGE BODY plch_pkgIS   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                                                                         DECLARATIONDO_STUFF                                                                         DECLARATIONDO_STUFF                                                                         DEFINITIONDO_STUFF                                                                         DEFINITIONSQL>

(B)

CREATE OR REPLACE PACKAGE BODY plch_pkgIS   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                                                                         DECLARATIONDO_STUFF                                                                         DEFINITIONSQL>

(C)

CREATE OR REPLACE PACKAGE BODY plch_pkgIS   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                                                                         CALLDO_STUFF                                                                         DECLARATIONDO_STUFF                                                                         DECLARATIONDO_STUFF                                                                         DEFINITIONDO_STUFF                                                                         DEFINITIONSQL>

(D)

CREATE OR REPLACE PACKAGE BODY plch_pkgIS   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                                                                         CALLDO_STUFF                                                                         DECLARATIONDO_STUFF                                                                         DECLARATIONDO_STUFF                                                                         DEFINITIONDO_STUFF                                                                         DEFINITIONSQL>

答案说明在202楼

2011-11-29 答案CD

A:在此选项中do_stuff被重载，所以DECLARATION 和 DEFINITION的显示行数是正确的。但是，并没有对do_stuff的调用。

B:为了使得DECLARATION 和 DEFINITION各显示两行，do_stuff必须被重载。

C:既有重载又有调用，正确。

D:同上，只是调用的地方不同。