开始

--INDEX BY TableSET SERVEROUTPUT ON;DECLARE  TYPE enm_tab_type IS TABLE OF       emp.ename%TYPE       INDEX BY BINARY_INTEGER;    enm_table enm_tab_type;BEGIN  enm_table(1):='1001';  enm_table(2):='1002';  enm_table(3):='1003';  enm_table(4):='1004';  enm_table(6):='1006';    dbms_output.put_line( 'NEXT(3) is:' ||enm_table.NEXT(3));  dbms_output.put_line( 'NEXT(4) is:' ||enm_table.NEXT(4));  dbms_output.put_line( 'PRIOR(6) is:' ||enm_table.PRIOR(6));  END;/

运行结果：

anonymous block completedNEXT(3) is:4NEXT(4) is:6PRIOR(6) is:4

也就是说 index 可以下标不连续。

结束