随笔分类 -  Develope

摘要：----------包定义 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');... 阅读全文