0

I have an sql code that is retreiving a row with more than one line, Is there a way to make it combine those two lines into one line.

select revertrsn  from LN08PENm where aano in(754,870,1136,1138,1139,1140)

the data coming in the row that I am retreiving is like this:

As per Mohammad Sulaiman's approval

by mail date 07/04/2009

And I want it to be in one line like this:

As per Mohammad Sulaiman's approval by mail date 07/04/2009
2
Contributors
8
Replies
10
Views
4 Years
Discussion Span
Last Post by sofien.fkih
0
SELECT group_concat(revertrsn separator '  ') from LN08PENm  #for mysql
SELECT wm_concat(revertrsn)from LN08PENm                      # for oracle

Edited by code739

0

how about this

select LISTAGG(column, ',')WITHIN GROUP (ORDER BY column) from tablename;

0

I am using oracle 10g, and I read that link, but it dont discuss (two lines in one cell).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.