Expert: Suchitra Joshi - 10/24/2009

Question
In Oracle I want to select No of rows into Single Row.
For example (In the huge records)
Name Address contact-no
N1    A1       123
N2    A2       456
N3    A3       678

Output I want to print

Name Address contact-no
N1    A1       123        N2    A2       456   N3    A3       678

How get the above output using pivot or any other way?
Thanks in advance

Answer
Hi Prakash,

There are multiple ways to get this result. The possible ways are listed at this site -

http://www.dba-oracle.com/t_display_multiple_column_values_same_rows.htm

You can use the stragg user defined function as described at the following link (Custome aggregate functions) -

http://www.oratechinfo.co.uk/delimited_lists_to_collections.html

Hope this helps.

Regards

Suchitra