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

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

CREATEORREPLACEPROCEDUREplch_show_status(object_name_inINVARCHAR2,type_inINVARCHAR2)ISl_statususer_objects.status%TYPE;BEGINSELECTob.statusINTOl_statusFROMuser_objectsobWHEREobject_name=object_name_inANDobject_type=type_in;DBMS_OUTPUT.put_line(type_in||''||object_name_in||':'||l_status);EXCEPTIONWHENNO_DATA_FOUNDTHENDBMS_OUTPUT.put_line(type_in||''||object_name_in||':UNDEFINED');END;/

我又创建了这个包：

CREATEORREPLACEPACKAGEplch_pkgISPROCEDUREdo_stuff;END;/CREATEORREPLACEPACKAGEBODYplch_pkgISPROCEDUREdo_stuffISBEGINNULL;END;END;/

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

BEGINplch_show_status('PLCH_PKG','PACKAGE');plch_show_status('PLCH_PKG','PACKAGEBODY');END;/

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

PACKAGEPLCH_PKG:UNDEFINEDPACKAGEBODYPLCH_PKG:UNDEFINED

(A)

DROPPACKAGESPECIFICATIONplch_pkg/DROPPACKAGEBODYplch_pkg/

SQL>DROPPACKAGESPECIFICATIONplch_pkg2/DROPPACKAGESPECIFICATIONplch_pkgORA-00933:SQL命令未正确结束SQL>DROPPACKAGEBODYplch_pkg2/PackagebodydroppedSQL>SQL>BEGIN2plch_show_status('PLCH_PKG','PACKAGE');3plch_show_status('PLCH_PKG','PACKAGEBODY');4END;5/PACKAGEPLCH_PKG:VALIDPACKAGEBODYPLCH_PKG:UNDEFINEDPL/SQLproceduresuccessfullycompletedSQL>

(B)

DROPPACKAGEplch_pkg/DROPPACKAGEBODYplch_pkg/

SQL>DROPPACKAGEplch_pkg2/PackagedroppedSQL>DROPPACKAGEBODYplch_pkg2/DROPPACKAGEBODYplch_pkgORA-04043:对象PLCH_PKG不存在SQL>SQL>SQL>BEGIN2plch_show_status('PLCH_PKG','PACKAGE');3plch_show_status('PLCH_PKG','PACKAGEBODY');4END;5/PACKAGEPLCH_PKG:UNDEFINEDPACKAGEBODYPLCH_PKG:UNDEFINEDPL/SQLproceduresuccessfullycompletedSQL>

(C)

DROPPACKAGESPECIFICATIONANDBODYplch_pkg/

SQL>DROPPACKAGESPECIFICATIONANDBODYplch_pkg2/DROPPACKAGESPECIFICATIONANDBODYplch_pkgORA-00933:SQL命令未正确结束SQL>SQL>SQL>BEGIN2plch_show_status('PLCH_PKG','PACKAGE');3plch_show_status('PLCH_PKG','PACKAGEBODY');4END;5/PACKAGEPLCH_PKG:VALIDPACKAGEBODYPLCH_PKG:VALIDPL/SQLproceduresuccessfullycompletedSQL>

(D)

DROPPACKAGEplch_pkg/

SQL>DROPPACKAGEplch_pkg2/PackagedroppedSQL>SQL>SQL>BEGIN2plch_show_status('PLCH_PKG','PACKAGE');3plch_show_status('PLCH_PKG','PACKAGEBODY');4END;5/PACKAGEPLCH_PKG:UNDEFINEDPACKAGEBODYPLCH_PKG:UNDEFINEDPL/SQLproceduresuccessfullycompletedSQL>

答案BD

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