confusing with your question ?you have already realized the coding for navigationDECLARE
i BINARY_INTEGER:=0;
TYPE tabletype IS TABLE OF emp.ename%TYPE
INDEX BY BINARY_INTEGER;
vtab TABLETYPE;
CURSOR cur_emp IS SELECT ename FROM emp;
j integer :=0;
BEGIN
FOR rec IN cur_emp
LOOP
i:=i+1;
vtab(i):=rec.ename;
END LOOP;
FOR N IN 1..vtab.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE(vtab(N));
j := j + 1;
END LOOP;
i:=1;
DBMS_OUTPUT.PUT_LINE('The First:'||vtab(1));--first
DBMS_OUTPUT.PUT_LINE('The Next:');
DBMS_OUTPUT.PUT_LINE('The Privious:');
DBMS_OUTPUT.PUT_LINE('The Last:'||vtab(j));--last
END;
/光说不练之龙飞虎
i BINARY_INTEGER:=0;
TYPE tabletype IS TABLE OF emp.ename%TYPE
INDEX BY BINARY_INTEGER;
vtab TABLETYPE;
CURSOR cur_emp IS SELECT ename FROM emp;
j integer :=0;
BEGIN
FOR rec IN cur_emp
LOOP
i:=i+1;
vtab(i):=rec.ename;
END LOOP;
FOR N IN 1..vtab.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE(vtab(N));
j := j + 1;
END LOOP;
i:=1;
DBMS_OUTPUT.PUT_LINE('The First:'||vtab(1));--first
DBMS_OUTPUT.PUT_LINE('The Next:');
DBMS_OUTPUT.PUT_LINE('The Privious:');
DBMS_OUTPUT.PUT_LINE('The Last:'||vtab(j));--last
END;
/光说不练之龙飞虎
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货