Oracle PLSQL示例2
Sql代码 www.2cto.com
— Created on 2010/04/16 by NAN
declare
— Local variables here
c_tobe com.cRef;
TYPE t_table IS TABLE OF kbis% ROWTYPE;
v_t_table t_table;
begin
— Test statements here
SELECT t.* BULK COLLECT INTO v_t_table FROM kbis t; –取出所有数据
FOR i IN 1 .. v_t_table.COUNT LOOP
dbms_output.put_line(v_t_table(i).k002);
END LOOP;
oracle账号
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line( Sqlerrm);
end;