Re: viewing long data with sqlplus
From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1997/06/06
Message-ID: <5n97dc$m9n_at_news.Informatik.Uni-Oldenburg.DE>#1/1
Date: 1997/06/06
Message-ID: <5n97dc$m9n_at_news.Informatik.Uni-Oldenburg.DE>#1/1
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_NAMEDATA_TYPE DATA_LENGTH COLUMN_ID
------------------------------ ------------------------------ --------- ----------- ---------- 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-102Received on Fri Jun 06 1997 - 00:00:00 CEST