Re: SQL problem

From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/08/26
Message-ID: <1996Aug26.120954.8499_at_mcrcr6>#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

In SQL*PLUS the long is set to 80 character by default. So when you select a long column it will display only 80 characters.

You can see the current setting for long by typeing the following at SQL prompt :

SQL> show long

If you want to display more than 80 characters then from SQL prompt :

SQL> set long nnn  

where nnn is the number of characters that you want to display. It cannot exceed MAXDATA values.

Look into SQL*PLUS help for these settings. Type

SQL> help set

Good luck,
Venkateswara Rao

/-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\

| Venkateswara R.Polisetti                 Email: vrao_at_sctcorp.com  |
| SCT Utility Systems, Inc.             Phone(O): (803) 935-8160    |
| 9 Science Court                            (R): (803) 736-1609    |
| Columbia, SC  29203-9344                                          |

\-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/ Received on Mon Aug 26 1996 - 00:00:00 CEST