Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Initialization of 2011-11-8 packet variables

2025-01-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Http://www.itpub.net/thread-1499223-12-1.html

119 floor

What will appear on my screen after executing the following statements?

CREATE OR REPLACE PACKAGE plch_pkgIS g_public NUMBER: = 1; PROCEDURE do_stuff; FUNCTION get_stuff RETURN NUMBER;END;/CREATE OR REPLACE PACKAGE BODY plch_pkgIS PROCEDURE do_stuff IS BEGIN DBMS_OUTPUT.put_line (g_public); END; FUNCTION get_stuff RETURN NUMBER IS BEGIN do_stuff; RETURN g_public + 1; END;BEGIN DBMS_OUTPUT.put_line (g_public); g_public: = 2ten end / BEGIN DBMS_OUTPUT.put_line (plch_pkg.get_stuff); plch_pkg.g_public: = plch_pkg.get_stuff; DBMS_OUTPUT.put_line (plch_pkg.get_stuff); END;/

(A)

one

(B)

twelve

(C)

one hundred and twenty three

(D)

1234

(E)

12334

(F)

123234

The measured answer is F

SQL > Package createdPackage body created123234PL/SQL procedure successfully completedSQL >

The answer is on the 125th floor

2011-11-8 answer F.

The initial value of the header declaration precedes the packet body. The initialization code is executed the first time the packet is called, thus overwriting the initial value in the header.

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report