æ¥è¯¢è¾åºææåå·¥ç¼å·ï¼å§åï¼å·¥èµï¼PLSQL表类åï¼
DECLARE
TYPE emp_table_type IS TABLE OF employees%ROWTYPE INDEX BY BINARY_INTEGER;
e emp_table_type;
CURSOR emp_cursor IS
SELECT * FROM employees;
BEGIN
OPEN emp_cursor;
FETCH emp_cursor BULK COLLECT
INTO e;
FOR i IN 1 .. e.count LOOP
dbms_output.put_line('ç¼å·' || e(i).employee_id);
dbms_output.put_line('å§å' || e(i).last_name);
dbms_output.put_line('å·¥èµ' || e(i).salary);
dbms_output.put_line('----------------------------');
END LOOP;
CLOSE emp_cursor;
END;
(5)æ¥è¯¢è¾åºææåå·¥ç¼å·ï¼å§åï¼å·¥èµï¼éè¿limitæ§å¶æåçæ°æ®éï¼
DECLARE
TYPE emp_table_type IS TABLE OF employees%ROWTYPE
INDEX BY BINARY_INTEGER;
e emp_table_type;
CURSOR emp_cursor IS
SELECT * FROM employees;
BEGIN
OPEN emp_cursor;
FETCH emp_cursor BULK COLLECT INTO e LIMIT 6 ;
FOR i IN 1..e.count LOOP
dbms_output.put_line('ç¼å·' || e(i).employee_id);
dbms_output.put_line('å§å' || e(i).last_name);
dbms_output.put_line('å·¥èµ' || e(i).salary);
dbms_output.put_line('----------------------------');
END LOOP;
CLOSE emp_cursor;
END;
温馨提示:内容为网友见解,仅供参考