Go to asktom.oracle.com and search for stragg. Raj On Tue, 19 Oct 2004 18:07:37 -0700, SRIDHARAN, SAN (SBCSI) <ss4569@xxxxxxx> wrote: > Here the output from the table test1 > > Select * from test1; > > N1 > --- > > A > B > C > D > E > F > > Is there an Oracle function or is there a Sql statement that will print > the following result without us create a function. > > Result > ----------- > > A,B,C,D,D,F > > Thanks. > -- > //www.freelists.org/webpage/oracle-l > -- ------------------------------ -- //www.freelists.org/webpage/oracle-l