DROP PACKAGE BODY package_name; 在数据字典中查看包的信息 SELECT text FROM user_source WHERE name = 'COMM_PKG' AND type = 'PACKAGE'; SELECT text FROM user_source WHERE name = 'COMM_PKG' AND type = 'PACKAGE BODY'; 创建包的一般规则 立足于将来反复重用来构建package 先定义 package specificati...
The Oracle Drop Package Body Tool allows users to select a Package Body to be dropped. The tool then generates the SQL to drop the Package Body. Listed below is an example SQL statement generated by the Drop Package Body Tool. DROP PACKAGE BODY TESTUSER.TEST_PACKAGE_BODY ...
SQL> SELECT DBMS_METADATA.GET_DDL('PACKAGE','ADDFUN_PKG') FROM DUAL; 06. 删除包 SQL> DROP PACKAGE ADDFUN_PKG; 程序包已丢弃。
drop package 包名; 例如: drop package pkg_cccs;
drop package包头名 删除包体: drop package body包体名 重新编译包头: alter package包名 compile package 重新编译包体: alter package包名 compile package body 在包头中说明的对象可以在包外调用,调用的方法和调用单独的过程或函数的方法基本相同, 惟一的区别就是要在调用的过程或函数名前加上包的名字(中间用“....
ADDFUN_PKG VALID PACKAGE 02. 加入/修改项 --- SQL> CREATE OR REPLACE PACKAGE ADDFUN_PKG 2 AS 3 FUNCTION FN_ADDONE(ANUM NUMBER) RETURN NUMBER; 4 END; 5 / 程序包已创建。 SQL> CREATE OR REPLACE PACKAGE BODY ADDFUN_PKG 2 AS 3 4 FUNCTION...
DROP PACKAGE Synopsis DROP PACKAGE [BODY][schema.]package_name Removes a package ( package_name) from the database. Keyword BODY Specifies that only the package body is to be dropped. If this keyword is omitted, both the package body and specification will be removed. Note The package to ...
select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编译。 ORA-04065:未执行,已更改或删除stored procedureXXX(过程名) 错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作...
stored procedure function 存储过程和函数;package packagebody 包和包体。 ORACLE常用操作 创建表:create table emp() 删除表:drop table emp() 查看完整表:select * from emp 关键字:primary key 非空: not null 新增: insert into emp values()
SQL_K_OCTAPB 98 alter package body SQL_K_OCTDPB 99 drop package body SQL_K_OCTCDR 157 create directory SQL_K_OCTDDR 158 drop directory SQL_K_OCTCLB 159 create library SQL_K_OCTCJV 160 create java SQL_K_OCTAJV 161 alter java SQL_K_OCTDJV 162 drop java SQL_K_OCTCOP...