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;


- Andrew


Reply via email to