RE: sqlplus extract question...

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'cstephens16@xxxxxxxxx'" <cstephens16@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 6 Jan 2005 08:39:14 -0500


Can you show us the Sql you are running?


-----Original Message-----
From: Chris Stephens [mailto:cstephens16@xxxxxxxxx] 
Sent: Wednesday, January 05, 2005 7:35 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: sqlplus extract question...

I'm creating an extract of some data that will be qa'd in an excel
spreadsheet.  I'm creating a comma delimited file and am including the
column headings.  There are about 60 columns from 5 or 6 tables.
After (approximately) the fifteenth column, the headings become blank
and I can't figure out why.  The data is fine but the headings are
missing.  I'm not giving the columns any aliases or anything.  Is this
a setting in sqlplus?  A quick look through my O'reilly sqlplus book
didn't do me any good.  Before I spend some significant time trying to
figure out what is causing this, i thought i'd start here.

any ideas?


...sarcastism welcome (expected)! :)

Other related posts: