OraFAQ Forum: SQL & PL/SQL » Comma separated values

Home » SQL & PL/SQL » SQL & PL/SQL » Comma separated values (Oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Comma separated values [message #645579]

Wed, 09 December 2015 02:41

ssyr22
Messages: 38
Registered: December 2015
Location: PUNE

Member

HI All,
I want to display comma separated values but when I used LISTAGG function for this it give me error string is too long.
Is there any other alternate solution? please help

Report message to a moderator

Re: Comma separated values [message #645585 is a reply to message #645579]

Wed, 09 December 2015 04:19

JNagtzaam
Messages: 36
Registered: July 2015
Location: Alkmaar

Member

set colsep ','

Report message to a moderator

Re: Comma separated values [message #645586 is a reply to message #645579]

Wed, 09 December 2015 04:31

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/199227/644830/#msg_644830

Report message to a moderator

Re: Comma separated values [message #645591 is a reply to message #645579]

Wed, 09 December 2015 06:36

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

ssyr22 wrote on Wed, 09 December 2015 02:41

HI All,
I want to display comma separated values but when I used LISTAGG function for this it give me error string is too long.
Is there any other alternate solution? please help

What does the listagg function have to do with column separation characters in your result set?

Can you debug code that you cannot see?
Neither can anyone else.

Report message to a moderator

Re: Comma separated values [message #645592 is a reply to message #645579]

Wed, 09 December 2015 06:38

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

Is this just a continuation of your other thread?

Report message to a moderator

Previous Topic:	Find Out Odd Range
Next Topic:	Load data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 12 20:47:17 CDT 2026