怎么理解数据库包和包体的删除语法

本篇内容主要讲解"怎么理解数据库包和包体的删除语法"，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习"怎么理解数据库包和包体的删除语法"吧!

我创建了这个小工具程序来显示一个指定对象的状态：

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;/

我又创建了这个包：

CREATE OR REPLACE PACKAGE plch_pkgIS   PROCEDURE do_stuff;END;/CREATE OR REPLACE PACKAGE BODY plch_pkgIS   PROCEDURE do_stuff   IS   BEGIN      NULL;   END;END;/

我执行了下列选项中的语句之后再执行这个块：

BEGIN   plch_show_status ('PLCH_PKG', 'PACKAGE');   plch_show_status ('PLCH_PKG', 'PACKAGE BODY');END;/

哪些选项会产生这两行输出？

PACKAGE PLCH_PKG: UNDEFINEDPACKAGE 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_pkgORA-00933: SQL 命令未正确结束SQL> DROP PACKAGE BODY plch_pkg  2  /Package body droppedSQL> SQL> BEGIN  2     plch_show_status ('PLCH_PKG', 'PACKAGE');  3     plch_show_status ('PLCH_PKG', 'PACKAGE BODY');  4  END;  5  /PACKAGE PLCH_PKG: VALIDPACKAGE BODY PLCH_PKG: UNDEFINEDPL/SQL procedure successfully completedSQL>

(B)

DROP PACKAGE plch_pkg/DROP PACKAGE BODY plch_pkg/

SQL> DROP PACKAGE plch_pkg  2  /Package droppedSQL> DROP PACKAGE BODY plch_pkg  2  /DROP PACKAGE BODY plch_pkgORA-04043: 对象 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: UNDEFINEDPACKAGE BODY PLCH_PKG: UNDEFINEDPL/SQL procedure successfully completedSQL>

(C)

DROP PACKAGE SPECIFICATION AND BODY plch_pkg/

SQL> DROP PACKAGE SPECIFICATION AND BODY plch_pkg  2  /DROP PACKAGE SPECIFICATION AND BODY plch_pkgORA-00933: SQL 命令未正确结束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: VALIDPACKAGE BODY PLCH_PKG: VALIDPL/SQL procedure successfully completedSQL>

(D)

DROP PACKAGE plch_pkg/

SQL> DROP PACKAGE plch_pkg  2  /Package droppedSQL> SQL> SQL> BEGIN  2     plch_show_status ('PLCH_PKG', 'PACKAGE');  3     plch_show_status ('PLCH_PKG', 'PACKAGE BODY');  4  END;  5  /PACKAGE PLCH_PKG: UNDEFINEDPACKAGE BODY PLCH_PKG: UNDEFINEDPL/SQL procedure successfully completedSQL>

答案BD

到此，相信大家对"怎么理解数据库包和包体的删除语法"有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！