Toad World® Forums

Make it easy to do a LISTAGG


#1

I used to be able to do thios in Hyperion! Help me by making it easier in Toad Data Point


#2

ListAgg still works in Toad if you are connected to an Oracle database. If you are connected to Sql Server it is a little more complicated but you can accomplish the same thing with Stuff and For XML Path (see this link: https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server ). It is database dependent not Toad dependent. I prefer ListAgg but I am not using Oracle right now :frowning: