Forum Discussion
Concatenate lines
I have a table in an Oracle database that stores several lines that refers to only one line in another table. I would like to know if there is a way to transform this lines in one unique line. ...
Anonymous
If I get you right, try:
Column = CONCATENATE([YP_CHAVE],[YP_SEQ])
So for the new column you should have values like 000001001 for text data type,it might show 11 if they are numerical data type. But with either way,each role should be unique.
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I need to join the lines where YP_CHAVE is the same. The values in column YP_TEXTO is brocken down in several lines.
So I want to make a group by YP_CHAVE and concatenate the lines in YP_TEXTO where YP_CHAVE repeats.
Take a look in the example above. This 3 lines have to be one unique line because the YP_CHAVE is the same for all.
The column YP_SEQ shows where the message begins and end in YP_TEXTO.