If you know why the below piece of code wont go into an infinite loop in Oracle, then you know a very important concept of Oracle database.
FOR x in (SELECT * from t) LOOP
INSERT INTO t values (x.user_name, x.user_id, x.created);
Its a direct lift from Thomas Kyte's text book.
Buy the book if you don't know why or thinks that it will go into infinite loop.