- Write a valid select statement in editor.
- Select the said select statement
- Right click and select 'Code template',
in my case that selection of 'Code Template' alone change SELECT statement to a
FOR rec in (SELECT ... ) LOOP .. end loop;
which is expected.
Thank you for the answer, but...
It seems that this behaviour is hardcoded, I don't have any template including #for# keyword and even if I include one the result is always the same (the for loop).
So I still don't understand how to use this keyword.
Anyway thank you for this 'trick'.