oracle数组类型简单实例介绍
Oracle数组一般可以分为固定数组和可变数组
?固定数组
declaret_record1 test%rowtype;cursor cur_test(v_id in varchar2) isselect id,mc from testwhere id <= v_id;t_record2 cur_test%rowtype;beginfor row_test in cur_test('333') loopt_record1.id := row_test.id;t_record1.mc := row_test.mc;t_record2.id := row_test.id;t_record2.mc := row_test.id;dbms_output.put_line('t_record1:'||t_record1.id||'---'||t_record1.mc);dbms_output.put_line('t_record2:'||t_record2.id||'---'||t_record2.mc);dbms_output.put_line('row_test:'||row_test.id||'---'||row_test.mc);dbms_output.put_line('================loop '||cur_test%rowcount||' times.');end loop;exception when others thendbms_output.put_line(sqlcode||sqlerrm);end;======================================================================================declaretype t_record is record(id test.id%type,mc test.mc%type);var_record t_record;counter number default 0;beginfor row_test in (select id,mc from test) loopcounter := counter + 1;var_record.id := row_test.id;var_record.mc := row_test.mc;dbms_output.put_line('var_record:'||var_record.id||'---'||var_record.mc);dbms_output.put_line('row_test:'||row_test.id||'---'||row_test.mc);dbms_output.put_line('================loop '||counter||' times.');end loop;exception when others thendbms_output.put_line(sqlcode||sqlerrm);end;
?转载自http://www.111cn.net/database/Oracle/41204.htm