troubleshooting Question

SqlPlus Report Generation Column Headings Truncated

Avatar of ignition00
ignition00 asked on
Oracle Database
3 Comments1 Solution10585 ViewsLast Modified:
Running SQL Plus on Oracle 10g.

When creating reports I find that column headings are truncated to the maximum length of the column data.  This is causing problems becuase the data is to be imported into Access and full heading names are required.  A read of the documentation seems to say that there is no way round this but wondered if anyone had some magic spells, rain dances or other proven methods for getting this to work properly.

My script is:

<code>
set echo off
set arraysize 5000
set colsep ';'
set sqlblanklines on
set linesize 10000
set trimspool on

set heading on
set pagesize 50000
set timing off
set termout off
set feedback off
set verify off
set concat on

COLUMN MANDT  TITLE 'MANDT'  FORMAT A5
<<snip>>
COLUMN DEAR6  TITLE 'DEAR6'  FORMAT A5


SPOOL <<snip>>.TXT
select * from SAPR3.KNA1 where rownum < 11;
SPOOL OFF
</code>

Sample output:
MAN;KUNNR     ;LAN;NAME1                              ;
010;1000000000;GB ;name removed                       ;


Note the first column "MAN" should read "MANDT"

Thanks
ASKER CERTIFIED SOLUTION
jwahl

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros