01. 新建包
02. 加入/修改项
03. 删除项
04. 访问项
05. 查询包
06. 删除包
==============
01. 新建包
------------
进行创建:
SQL> CREATE PACKAGE ADDFUN_PKG
2 IS
3 END ADDFUN_PKG;
4 /
程序包已创建。
进行包对象查看:
SQL> SELECT SUBSTR(OBJECT_NAME,0,10),STATUS,OBJECT_TYPE
2 FROM USER_OBJECTS;
SUBSTR(OBJECT_NAME,0 STATUS OBJECT_TYPE
-------------------- ------- ------------------
ADDFUN_PKG VALID PACKAGE
SP_STUDENT VALID PROCEDURE
STUDENT VALID TABLE
V_STUDENT VALID VIEW
或:
SQL> SELECT SUBSTR(OBJECT_NAME,0,10),STATUS,OBJECT_TYPE
2 FROM USER_OBJECTS