html&css&js/DB
Oracle PL/SQL
ddakker
2010. 4. 11. 23:59
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;