SQL & PL/SQL

Hi,

To create header for CSV , we are using table data.

Select h1 from tab1 where SUB_HEADER in('AA','AB','AC','AD');

o/p is 
A,A,A,A

Here AA,AB,AC,AD are sub headers and A is header.

When am creating CSV file using these,A is coming in each cell of first row.

A   A     A    A
AA  AB    Ac   AD
data........

But I need to merge all those duplicates into single cell as below and remaining same

A
AA AB AC AD
data.....

Edited by: 925896 on Feb 12, 2013 9:28 PM