We have a specific requirement of Concatenating all the columns of a table in single select statement using ~ as the column delimiter.

Select col1||'~'||col2 from x.

The expression length varry depends on the number of columns in the table.

So far it was working fine and suddenly, we are getting only 32 bytes of the result. The result is coming properly if number of columns are less than 121 and it is giving 12 bytes results if the number of columns exceeds 121.

Also if we spilit the expression into 4 colums by grouping 100 columns in each group it is working fine.

Is it because of any Parameter setting in Oracle or related to any OS level setting.

It will be of great help if some on help to resolve.