Home » SQL & PL/SQL » Client Tools » Help to stop last field from wrapping in report
Help to stop last field from wrapping in report [message #270073] Tue, 25 September 2007 10:52 Go to next message
duanecwilson
Messages: 6
Registered: September 2007
Location: Greenville, SC
Junior Member

I have a report that comes out beautiful and opens in Excel with the extension changed. The only problem is the very last column has a description type field (SEND_REASON) in it which only sometimes is a liitle too long to put in the column made, I guess by default by SQL Plus. I only need it to be about 10 characters longer. What happens is it wraps to the next line and opening in Excel, I get different row widths. I just want the last column to end up a little longer. All the others work fine. They just default to the maximum width of the field. I don't know why the last one doesn't. I don't know if there is a maximum column length set by default that I can override or what. Here is the script that I run that otherwise works perfectly:
SET SERVEROUTPUT ON
SET MARKUP HTML ON
SET ECHO OFF
SET PAGESIZE 33  -- Ideal page length for Excel - headers repeat
SET TERMOUT OFF
SPOOL \\Nsgnvl_files\RCO\R_C_Assurance\Work\Duane\test3.xls
SELECT CIRCUIT_ID
, CONDENSED_EC_CIRCUIT
, VENDOR_ID
, CVBI_KEY
, END_DATE
, CIRCUIT_TYPE
, ALOC, ZLOC
, QTY_CVBI_CAT
, QTY_CKT_CAT
, VEN_TYP
, ALOC_VALID
, ZLOC_VALID
, DUPS_SAME
, AZ_SAME
, SRV_TYP_OK
, CLLIS_OK
, MTPT_OK
, CAP_OK
, SEND_LCA
, SEND_REASON  -- This is the column that wraps when too long
FROM RPT_DS1_CNT_CAT_vw WHERE SEND_LCA='YES' ORDER BY CVBI_KEY;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON
SET PAGESIZE 20
SET TERMOUT ON
SET SERVEROUTPUT OFF
PAUSE 'Done - Press ENTER to exit ...'
--EXIT

Thanks for any help.

Re: Help to stop last field from wrapping in report [message #270083 is a reply to message #270073] Tue, 25 September 2007 12:13 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SET LINESIZE to enlarge your line.

Regards
Michel
Previous Topic: sqlplus
Next Topic: Explain Plan in different Tablespace
Goto Forum:
  


Current Time: Thu Dec 08 08:18:17 CST 2016

Total time taken to generate the page: 0.11411 seconds