Gents. 10g R2.
with test_tab as
(select 'x'||chr(10)||'y'||chr(10)||chr(10)||'z' tester from dual)
select tester from test_tab
produces
x
y
z
I require
x
y
z
There's a lot of examples on how to end up with xzy, but I need to maintain the carriage returns, just strip out blank lines.
I've been trying with posix [:cntrl:] but it doesn't seem to want to work. Question: how to get the desired output?
If this has been answered on another post, please point me in the right direction and accept my apologies!