Re: viewing long data with sqlplus

Hi,

>I wrote in article
><5n0fgv$fjf_at_news.Informatik.Uni-Oldenburg.DE>...
>> Hi,
>>
>> how can I view long (ca. 10000 characters) data within sql*plus?
>>
>> When I select a row that definitively should contain data sql*plus
>> prints out nothing!

"DEC51330331" <garaque_at_telcel.net.ve> wrote:

>User the sqlplus command
>set long 10000
>
>and
>
>set arraysize 1

Unfortunately this does not work:

SQL> set line 132
SQL> set long 10000
SQL> set arraysize 1
SQL> select * from test where b is not null;

         A B

         2
      1000
      1999
      2000
      2001
      9999

6 rows selected.

SQL> select TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH,COLUMN_ID from user_tab_columns where TABLE_NAME = 'TEST';

TABLE_NAME                     COLUMN_NAME

------------------------------ ------------------------------
--------- ----------- ----------
TEST                           A                              NUMBER
22          1
TEST                           B                              LONG
0          2

A is a primary key, btw.

How can I get my data???

        Clueless, Gerhard.

-- 
 Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE

OFFIS                   | | | | | |       Tel.:   0441/9722-122
Escherweg 2             | | | | | |       Sekr.:  0441/9722-113 oder -101
D-26121 Oldenburg       |O|F|F|I|S|       Fax:    0441/9722-102