pl/sql表类似于数组,元素个数无限制,下标可以为负数;多条单列,可以与其他类型配合使用
create or replace
PROCEDURE PR_TABLE_VARIABLE
AS
BEGIN
DECLARE
/*pl/sql记录*/
type V_RECORD IS RECORD(
rum NUMBER(10),
DEPTNO DEPT.DEPTNO%type,
DNAME DEPT.DNAME%type,
LOC DEPT.LOC%type
);
type TABTYPE is table of V_RECORD index by BINARY_INTEGER;
MYTAB TABTYPE;
IX NUMBER;
BEGIN
IX := 1;
FOR item IN (SELECT rownum,DEPTNO,DNAME,LOC FROM DEPT ORDER BY DEPTNO ASC)
LOOP
MYTAB(ITEM.rownum).rum := ITEM.rownum;
MYTAB(ITEM.rownum).DEPTNO := ITEM.DEPTNO;
MYTAB(ITEM.rownum).DNAME := ITEM.DNAME;
MYTAB(ITEM.rownum).LOC := ITEM.LOC;
IX := IX + 1;
END LOOP;
IX := MYTAB.First;
FOR item IN IX..MYTAB.count
LOOP
DBMS_OUTPUT.PUT_LINE(IX||' '''||MYTAB(IX).rum ||' '''||MYTAB(IX).DEPTNO||' '''||MYTAB(IX).DNAME||' '''||MYTAB(IX).LOC);
IX := MYTAB.next(IX);
END LOOP;
END;
END PR_TABLE_VARIABLE;