Display multiline text in SQL*Plus

[BMorley]

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

[gpsingh]

Read about the function ch().

[BMorley]

I have checked the Oracle docs but cannot find a reference to CH().

What would a typical example look like?

Thanks again

[gpsingh]

Sorry,

It is chr() and not ch().

select 'line 1' || chr(10) || 'line 2' from dual;

[Turtle]

Hello peeps,

I am losing the will to live! below is the connect string for Procedure Builder....

PL/SQL> .CONNECT DB scott/tiger@t:net:base
PDE-POC011 ORA-06401: NETCMN: invalid driver designator
PDE-POC004 General OCI error. An error message with more detailed information is supplied.

why? and where does the error message with more detail live.

I have used sql/plus and connected successfully to prove I can get in.

Thanks for any help.

Paul

[juniour_dba]

03-27-2001, 05:48 PM
Hello peeps,

I am losing the will to live! below is the connect string for Procedure Builder....

PL/SQL> .CONNECT DB scott/tiger@t:net:base
PDE-POC011 ORA-06401: NETCMN: invalid driver designator
PDE-POC004 General OCI error. An error message with more detailed information is supplied.

why? and where does the error message with more detail live.

I have used sql/plus and connected successfully to prove I can get in.

Thanks for any help.

Paul


when i run reports ı encountered same problem. i couldn't use reports exe in descktop. i use in it on bin folder. and i can connect so i recreate it again in my desktop.and solve it.
you must use from it 's source dont use shortcut .

ı hope this is help for you

gökhan dedeler
jnr dba

[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.