摘要:
----------包定义 create or replace package packtest as type string_array is table of varchar2(21) index by binary_integer; type int_array is table of number(4) index by binary_integer; procedure te... 阅读全文
摘要:
----建立测试数据 CREATE TABLE DEPT (DEPTNO NUMBER(2,0) NOT NULL, DNAME VARCHAR2(14) NULL, LOC VARCHAR2(13) NULL, PRIMARY KEY (DEPTNO) ); INSERT INTO Dept VALUES(11,'Sales','Texas');... 阅读全文