H. It seems that I don't get replies to a lot of my posts. Do I ask
the hard questions or just stupid ones? On sencond thought, don't answer
that... ;)
In any case, in reinventing the wheel, I decided to just create a function
that uses a REF CURSOR to generically concat the column for me:
Hey all,
In 8.1.7.4, does anyone have a SQL that will take the output from the
following:
SELECT sql_text
FROM PERFSTAT.STATS$SQLTEXT SS
WHERE SS.HASH_VALUE = :myhash
ORDER BY PIECE
...and append/concat all the rows into a single column.
I *know* someone's done this before and I don't want to