SQL problem
From: Paradox Account <s926058_at_acs.csc.cuhk.hk>
Date: 1996/08/25
Message-ID: <4vohmv$5ap_at_hpg30a.csc.cuhk.edu.hk>#1/1
Date: 1996/08/25
Message-ID: <4vohmv$5ap_at_hpg30a.csc.cuhk.edu.hk>#1/1
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 ,verylong 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 5841Received on Sun Aug 25 1996 - 00:00:00 CEST