Display multiline text in SQL*Plus

[WilliamR]

Perhaps I am missing something...

SQL> CREATE TABLE william_test2 (text_with_newlines CLOB);

Table created.

SQL> INSERT INTO william_test VALUES ('I wonder what
  2  the Procedure Builder question has
  3  to do with this thread which is
  4  about displaying text containing
  5  linefeeds' );

1 row created.


SQL> SELECT text_with_newlines FROM william_test2;

TEXT_WITH_NEWLINES
--------------------------------------------------------------------------------
I wonder what
the Procedure Builder question has
to do with this thread which is


1 row selected.

SQL>
SQL> show long
long 80
SQL> set long 2000
SQL> SELECT text_with_newlines FROM william_test2;

TEXT_WITH_NEWLINES
--------------------------------------------------------------------------------
I wonder what
the Procedure Builder question has
to do with this thread which is
about displaying text containing
linefeeds


1 row selected.