Is it possible to go to newline or put carriage return from a sql statement. I am not using any pl/sql block, so don't suggest using dbms_output.putline.

This is what I am doing:
select 'Execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('''|| LOCAL_TRAN_ID || ''');'
from dba_2pc_pending
order by fail_time;

That statement gives an output of all the transactions that I have to purge. But each statement has to have an explicit commit. So how can I achieve it. Putting commit in the same line does not work. I have tried that.

-Prasad.