Re: SQL problem

From: L.Cornelese <lcornel_at_caiw.nl>
Date: 1996/08/25
Message-ID: <4vqg7d$rgt_at_newsserv.caiw.nl>#1/1

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

> What do I do wrong ?
 

>--
 

> Best Regards,
 

> Lun Wing San
> ­Û ¥Ã ·s

>Email address : sunny_at_hkpc.org
>Telephone : (852)2758 5936 / (852)2788 5841

use "set long #" in SQL*Plus; this sets the maximum width (in characters) for displaying long values.

Hope this helps.

Lucy Cornelese

---

Lucy Cornelese email: lcornele_at_caiw.nl

HC Partners        phone: (31)174290731
Netherlands        fax  : (31)174290876

Received on Sun Aug 25 1996 - 00:00:00 CEST