Re: length of columns in a select

From: XU <xux_at_informa.bio.caltech.edu>
Date: 13 May 1999 23:53:05 GMT
Message-ID: <7hfol1$lp0@gap.cco.caltech.edu>

In Sqlplus, use "set long 1000" (or bigger) before select value of long type.

Robert XU

jgp (jguzman_at_audifilm.com) wrote:
: Hi,
: We are trying to do a select to a database table with data of type "long".
: The data are longer than 255 characters but we don't get them on the screen.
: We only get 80 characters, the width of the screen. We have tried with "set
: linesize 2000" but it does not work.
: Does anybody know what is happenning? Do we have to configure any parameter
: in the init.ora?...

: Data: we are executing this command from a telnet session. Oracle is 7.3.4.
: for hpux 10.20.

: Thanks and regards
: Jorge Tomé
Received on Thu May 13 1999 - 18:53:05 CDT