newline or carriage return in sql statement
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 || ''');'
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.