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>
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 CorpReceived on Tue Oct 16 2001 - 15:08:59 CEST