p1tchbl4ck
New Member
Given this query:\[code\]select distinct subject_keyfrom mytable\[/code\]Result: \[code\]subject_key-----------9089695990895823906901719066926590671321\[/code\]How do i write a query in Oracle (using Aqua Data Studio backend Oracle 8i) result:\[code\]subject_key-----------90896959,90895823,90690171,90669265,90671321\[/code\]THANKS ALL!Should I wish to change the output across instead of down like below. How do I write it, same platform. Thanks.\[code\]subject_key90896959, 90895823, 90690171, 90669265, 90671321\[/code\]