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
Jump to PostSELECT group_concat(revertrsn separator ' ') from LN08PENm #for mysql SELECT wm_concat(revertrsn)from LN08PENm # for oracle
Jump to Postwhat database are you using
SELECT group_concat(revertrsn separator ' ') from LN08PENm #for mysql
SELECT wm_concat(revertrsn)from LN08PENm # for oracle
Can this work on sql plus?
because it is showing me error.
what database are you using
oracle DB.
how about this
select LISTAGG(column, ',')WITHIN GROUP (ORDER BY column) from tablename;
It is still showing error.
invalid identifier.
I am using oracle 10g, and I read that link, but it dont discuss (two lines in one cell).
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.