RE: Concat SQL_TEXT from Statspack tables.

2003-02-12 Thread Jesse, Rich
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:

Concat SQL_TEXT from Statspack tables.

2003-02-10 Thread Jesse, Rich
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