A few hours ago, I wrote:
>
> Simple add lines as shown:
>
> > for r in select * from tconcattest loop
> IF r.str IS NOT NULL THEN
> > output := output || r.str;
> END IF;
> > end loop;
>
This would probably be better:
for r in select * from tconcattest where str is not null loop
output := output || r.str;
end loop;