are you writing pl/sql? use loop structure.
if not, write a script, i.e. test.sql, put these two lines in the file:-
INSERT INTO MYTABLE (CCN, PRJ) VALUES ('100', '5102566');
INSERT INTO MYTABLE (CCN, PRJ) VALUES ('100', '1000238');
commit;
then run the script at sql command prompt:-
sql>@test
~za~
You can't bring back a dead thread!