Which loop function should I use to copy a small data and paste it to huge database in a repetitive mode?

Answer 1

If you know how many records there are, you can use the FOR loop

Otherwise you must use the WHILE loop....

Put them in a csv file and use the WHILE loop...

WHILE not eof( filePtr)

reads the next record

processes the record

writes the record to database

END WHILE