oracle - PL/SQL FOR loop after the WITH statement

Question

I wrote a WITH statement as follow

with tempTable as ( select t1.c1, t1.c2, t2.c3 from (t1 join t2))

select * from tempTable gives me:

c1	c2	c3
circle	blue	alpha
circle	red	beta

Answer 1

temptable is not table but it is CTE. you can use it directly in the loop as follows:

BEGIN 
   for i in (select * from 
               (with tempTable as 
                   ( select t1.c1, t1.c2, t2.c3 from (t1 join t2)) 
               select * from tempTable)
            ) LOOP
   DBMS_OUTPUT.PUT_LINE (i);
   END LOOP;
END;