declare Cursor emp_cursor is Select seq,subject from board; begin dbms_output.put_line('seq subject'); dbms_output.put_line('------ ---- -------'); for c1 in emp_cursor loop dbms_output.put_line(to_char(c1.seq) || ' ' || c1.subject); insert into insert_test(test)values(c1.subject); end loop; end;
Oracle PL/SQL
2010. 4. 11. 23:59