unexistance 3 Report post Posted September 4, 2007 Dear Otai Oracle,Macam mana nak masukkan data dari cursor ke loop?contoh:DECLARE CURSOR C1 IS SELECT aa, bb ,cc, dd, .. --(23 column) FROM table1 WHERE aa='1330' AND bb='31/dec/2007'; BEGIN FOR R_C1 IN C1 LOOP INSERT INTO table2 VALUES (R_C1) EXIT WHEN C1%NOTFOUND; END LOOP; COMMIT; END;sebab bila run statement ni, dapat error invalid syntaxdekat line INSERT.1. ada error dekat syntax ke?tambah semicolon pun keluar error,buang kurungan R_C1 pun error jugak2. ada cara yang lagi mudah tak, selain tulis sebiji2 23 column name menggantikan R_C1 tu?(buat macam tu very error prone)Thanks in advance.. Quote Share this post Link to post Share on other sites
thalz142 0 Report post Posted September 5, 2007 Dear Otai Oracle,Macam mana nak masukkan data dari cursor ke loop?contoh:DECLARE CURSOR C1 IS SELECT aa, bb ,cc, dd, .. --(23 column) FROM table1 WHERE aa='1330' AND bb='31/dec/2007'; BEGIN FOR R_C1 IN C1 LOOP INSERT INTO table2 VALUES (R_C1) EXIT WHEN C1%NOTFOUND; END LOOP; COMMIT; END;sebab bila run statement ni, dapat error invalid syntaxdekat line INSERT.1. ada error dekat syntax ke?tambah semicolon pun keluar error,buang kurungan R_C1 pun error jugak2. ada cara yang lagi mudah tak, selain tulis sebiji2 23 column name menggantikan R_C1 tu?(buat macam tu very error prone)Thanks in advance..bang btol ke insert statemnnt tu?INSERT INTO table2 (namafieldmana?) VALUES (R_C1) EXIT WHEN C1%NOTFOUND; Quote Share this post Link to post Share on other sites
unexistance 3 Report post Posted September 5, 2007 kalau Oracle, tak perlu pun takpe.. asalkan bilangan column sama..Unless you're telling me, inside the loop, you have to use such statement, no shortcut, is it? Quote Share this post Link to post Share on other sites