Oracle SQL: displaying multiple columns per row

Until 11g, Oracle SQL did not have a direct mechanism for allowing multiple values from the same column to be displayed in the same row of output. SQL is designed not to disallow repeating values on a single line of output, but Oracle has several tricks f

www.dba-oracle.com