In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Http://www.itpub.net/thread-1499223-20-1.html
197 floor
I opened PL/Scope in the current session:
ALTER SESSION SET plscope_settings='identifiers:all'/
Then I created this header:
CREATE OR REPLACE PACKAGE plch_pkgIS PROCEDURE do_stuff;END plch_pkg;/
Which of the following queries implements a packet body, resulting in the following queries:
SELECT name, usage FROM user_identifiersWHERE object_name = 'PLCH_PKG' AND type IN (' PROCEDURE', 'FUNCTION') ORDER BY usage/
These results are output:
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 >
The answer is on the 202 floor.
2011-11-29 answer CD
A: do_stuff is overloaded in this option, so the number of rows displayed by DECLARATION and DEFINITION is correct. However, there is no call to do_stuff.
B: in order for DECLARATION and DEFINITION to display two lines each, do_stuff must be overloaded.
C: both overloading and calling, correct.
D: it's the same as above, but the place where it is called is different.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.