Re: Long type

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 16 Oct 2001 06:08:59 -0700
Message-ID: <9qhbhb02r1o_at_drn.newsguy.com>


In article <9455EAF0C99FD111B85B0060B067688A04FBB6CA_at_E40>, Богомол says...
>
>Hi everybody!
>Could anybody advice me how to get the value of the long type field in
>the following
>statement :
>select long_type_field from my_table ;
> if i do the above command, I get only some strings of that column on
>the screen.
>
>Thanks in advance
>A.Bogomol
>

SQL> set long N
SQL> select long_type_field from my_table;

set N to be as big as you want to see. It defaults to 80.

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Tue Oct 16 2001 - 15:08:59 CEST

Original text of this message