Hi All,

Can anybody tell how to display data in a Varchar2 column if the data contains newline characters. All I get is the first line. I've looked through the environment settings but nothing is immediately obvious.

Furthermore, I can enter newline characters when using SQL*Plus directly but when using a script the same statement generates errors.

Any advice is greatly welcome!!

Thx in advance

Ben