Re: SQL problem
Date: 1996/08/25
Message-ID: <4vq3hq$4b7a_at_elmo.cadvision.com>#1/1
In SQL*PLUS, use the command:
set long 2000
s926058_at_acs.csc.cuhk.hk (Paradox Account) wrote:
>Dear netters,
> I am using Oracle 7.3.2.2.0 on Sun Sparc 1000 with Solaris as the
>operating system.
> My table structure is
> table name : tbl
> field name : id varchar2(6)
> detail long
> I have written a script and executed in sqlplus and svrmgrl:
>
> update tbl set detail='It is a very , very, very ,very ,very ,very
>long field and it extends for severl long field. Moreover, the total
>field length is less than 2^31-1 bytes.' where id='102343';
> However, when I type :
> select detail from tbl where id='102343';
> Only partial detail can be seen (about 100 characters).
>--
> Best Regards,
> Lun Wing San
> Û ¥Ã ·s
>Email address : sunny_at_hkpc.org
>Telephone : (852)2758 5936 / (852)2788 5841
Received on Sun Aug 25 1996 - 00:00:00 CEST