Re: SQL problem

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 ?
>
> --
You cannot enter a full LONG value with SQLPLUS, you have to use some other method. You will face the same limit as a maxed out VARCHAR2 as far as data entry is concerned.

Once you get information into a LONG field the amount you see will be determined by two further settings, LONG and LONGC[hunksize], which you can set with

SET LONG 33000 (for example). The default value for LONG is 80. So it will only you show the first 80 characters. If you set LONG as above you'll see the first 33,000 characters (ie. the whole value) of the LONG field. Received on Mon Aug 26 1996 - 00:00:00 CEST