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