Home » Other » Test » Concatinate different lines (SQL Navigator 5)
Concatinate different lines [message #409923] Wed, 24 June 2009 08:20 Go to next message
ChristopheDW
Messages: 7
Registered: May 2007
Junior Member
I have several lines (variabel) and I want to concatinate them in one line/cell

e.g.
1. A
2. I
3. A

Wanted result:
AIA

It is possible that in some cases it are 2 lines or 4 or ...

Who can help me?
Re: Concatinate different lines [message #409929 is a reply to message #409923] Wed, 24 June 2009 08:49 Go to previous message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If it is a real question, you must put it in SQL.
It it is to test how to post you have to first read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Post a working Test case: create table and insert statements along with the result you want with these data.

Regards
Michel
Previous Topic: testing url
Next Topic: add image with fewer than 5 posts
Goto Forum:
  


Current Time: Sat Nov 09 21:13:04 CST 2024