您好,登錄后才能下訂單哦!
本篇內(nèi)容主要講解“怎么理解數(shù)據(jù)庫(kù)包和包體的刪除語(yǔ)法”,感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷,實(shí)用性強(qiáng)。下面就讓小編來(lái)帶大家學(xué)習(xí)“怎么理解數(shù)據(jù)庫(kù)包和包體的刪除語(yǔ)法”吧!
我創(chuàng)建了這個(gè)小工具程序來(lái)顯示一個(gè)指定對(duì)象的狀態(tài):
CREATE OR REPLACE PROCEDURE plch_show_status ( object_name_in IN VARCHAR2 , type_in IN VARCHAR2) IS l_status user_objects.status%TYPE; BEGIN SELECT ob.status INTO l_status FROM user_objects ob WHERE object_name = object_name_in AND object_type = type_in; DBMS_OUTPUT.put_line ( type_in || ' ' || object_name_in || ': ' || l_status); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line ( type_in || ' ' || object_name_in || ': UNDEFINED'); END; /
我又創(chuàng)建了這個(gè)包:
CREATE OR REPLACE PACKAGE plch_pkg IS PROCEDURE do_stuff; END; / CREATE OR REPLACE PACKAGE BODY plch_pkg IS PROCEDURE do_stuff IS BEGIN NULL; END; END; /
我執(zhí)行了下列選項(xiàng)中的語(yǔ)句之后再執(zhí)行這個(gè)塊:
BEGIN plch_show_status ('PLCH_PKG', 'PACKAGE'); plch_show_status ('PLCH_PKG', 'PACKAGE BODY'); END; /
哪些選項(xiàng)會(huì)產(chǎn)生這兩行輸出?
PACKAGE PLCH_PKG: UNDEFINED PACKAGE BODY PLCH_PKG: UNDEFINED
(A)
DROP PACKAGE SPECIFICATION plch_pkg / DROP PACKAGE BODY plch_pkg /
SQL> DROP PACKAGE SPECIFICATION plch_pkg 2 / DROP PACKAGE SPECIFICATION plch_pkg ORA-00933: SQL 命令未正確結(jié)束 SQL> DROP PACKAGE BODY plch_pkg 2 / Package body dropped SQL> SQL> BEGIN 2 plch_show_status ('PLCH_PKG', 'PACKAGE'); 3 plch_show_status ('PLCH_PKG', 'PACKAGE BODY'); 4 END; 5 / PACKAGE PLCH_PKG: VALID PACKAGE BODY PLCH_PKG: UNDEFINED PL/SQL procedure successfully completed SQL>
(B)
DROP PACKAGE plch_pkg / DROP PACKAGE BODY plch_pkg /
SQL> DROP PACKAGE plch_pkg 2 / Package dropped SQL> DROP PACKAGE BODY plch_pkg 2 / DROP PACKAGE BODY plch_pkg ORA-04043: 對(duì)象 PLCH_PKG 不存在 SQL> SQL> SQL> BEGIN 2 plch_show_status ('PLCH_PKG', 'PACKAGE'); 3 plch_show_status ('PLCH_PKG', 'PACKAGE BODY'); 4 END; 5 / PACKAGE PLCH_PKG: UNDEFINED PACKAGE BODY PLCH_PKG: UNDEFINED PL/SQL procedure successfully completed SQL>
(C)
DROP PACKAGE SPECIFICATION AND BODY plch_pkg /
SQL> DROP PACKAGE SPECIFICATION AND BODY plch_pkg 2 / DROP PACKAGE SPECIFICATION AND BODY plch_pkg ORA-00933: SQL 命令未正確結(jié)束 SQL> SQL> SQL> BEGIN 2 plch_show_status ('PLCH_PKG', 'PACKAGE'); 3 plch_show_status ('PLCH_PKG', 'PACKAGE BODY'); 4 END; 5 / PACKAGE PLCH_PKG: VALID PACKAGE BODY PLCH_PKG: VALID PL/SQL procedure successfully completed SQL>
(D)
DROP PACKAGE plch_pkg /
SQL> DROP PACKAGE plch_pkg 2 / Package dropped SQL> SQL> SQL> BEGIN 2 plch_show_status ('PLCH_PKG', 'PACKAGE'); 3 plch_show_status ('PLCH_PKG', 'PACKAGE BODY'); 4 END; 5 / PACKAGE PLCH_PKG: UNDEFINED PACKAGE BODY PLCH_PKG: UNDEFINED PL/SQL procedure successfully completed SQL>
答案BD
到此,相信大家對(duì)“怎么理解數(shù)據(jù)庫(kù)包和包體的刪除語(yǔ)法”有了更深的了解,不妨來(lái)實(shí)際操作一番吧!這里是億速云網(wǎng)站,更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢,關(guān)注我們,繼續(xù)學(xué)習(xí)!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。