RE: sqlplus extract question...

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 6 Jan 2005 08:39:14 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A971DD@exchsen0a1ma>

Chris,

Can you show us the Sql you are running?

Tom

-----Original Message-----

From: Chris Stephens [mailto:cstephens16_at_gmail.com] Sent: Wednesday, January 05, 2005 7:35 PM To: oracle-l_at_freelists.org
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?

tia!

...sarcastism welcome (expected)! :)
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 06 2005 - 07:34:48 CST