How do I JOIN lines into single line returned from SQL in one column?

Im trying to run the sql such as:

select 'TransactionId='|| ||',USER_DATA='|| from bla..bla.

the problem here is that the userdata () has very long v开发者_Go百科alues and results are shown as in the notepad ( and even very deterioted in excel):

TransactionId=12385031681, USER_DATA=This product

brought to you by

P&G SMS, < coumn3 > ...bla.bla

Now, i need to fix the value fetched in USER_DATA into one line rather than number of lines.

Can you please advise ?

Try to remove line breaks with replace:

replace(replace(USER_DATA,chr(10),''),chr(13),'')