help: column width changing within a query
Date: Fri, 04 Dec 1998 09:28:59 GMT
Message-ID: <748a0q$o2n$1_at_nnrp1.dejanews.com>
I'm using SQPlus to query an Oracle 8 table and select two columns- the first is an index number, the second is a CLOB. The first 30 records are displayed correctly. However, after the 31st record the width of the CLOB column goes down to 50 characters- the text is wr apped like this, instead of being displayed correctly.
The 30th record is different from the first 29- it only contains a few words- about 25 characters total. The other records contain multiple rows of text (similar to this dejanews article).
Could the size difference of this one record cause the display widths to change in the middle of a query? I experimented with various combinations of set linesize, set long, and column newline options, and all resulted in this problem after record #30. The program: set long 2000 set linesize 1024 column text newline [and/or format with different widths] select text_id, text from mydb.texttable;
Texttable contains columns text_id (N10), text (CLOB), and textlength (N6).
thanks for any ideas,
Kathryn
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 04 1998 - 10:28:59 CET