索引表

定义索引表
TYPE 类型名称 IS TABLE OF 数据类型 [NOT NULL]
INDEX BY [PLS_INTEGER | BINARY_INTEGER |
VARCHAR2(长度)] ;
DECLARE
TYPE info_index IS TABLE OF VARCHAR(20)
INDEX BY PLS_INTEGER ;
v_info info_index ;
BEGIN
v_info (1) := ‘VDATA’ ;
v_info (10) := ‘ORACLE’ ;
DBMS_OUTPUT.put_line(v_info(1)) ;
DBMS_OUTPUT.put_line(v_info(10)) ;
END ;
/

v_info (1) := ‘VDATA’ ;
v_info (10) := ‘ORACLE’ ;
IF v_info.EXISTS(10) THEN
DBMS_OUTPUT.put_line(v_info(1)) ;

v_info (‘公司名称’) := ‘海量数据（VDATA）’ ;
v_info (‘培训项目’) := ‘OCP培训’ ;
DBMS_OUTPUT.put_line(v_info(‘公司名称’)) ;
DBMS_OUTPUT.put_line(v_info(‘培训项目’)) ;

TYPE dept_index IS TABLE OF dept%ROWTYPE
INDEX BY PLS_INTEGER ;
v_dept dept_index ;
BEGIN
v_dept(0).deptno := 80 ;
v_dept(0).dname := ‘VDATA教学部’ ;
v_dept(0).loc := ‘北京’ ;