Re: Forget it , it is only a test

From: <gjlinker_at_geocities.com>
Date: 1998/12/27
Message-ID: <7669m2$4te$1_at_nnrp1.dejanews.com>#1/1


If the only thing you want is to export data from Oracle, you may want to have a look at my utility for Excel called Oraxcel.

It allows you to fetch data from Oracle into an MS Excel spreadsheet. From there you can use the flexibility of MS Excel to handle the data furhter (save it, print it...

Oraxcel can be gotten from http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker

In article <7427ik$j4s$1_at_nnrp1.dejanews.com>,   zuojiangping_at_my-dejanews.com wrote:
> In article <3663E977.C5D220D9_at_Feist.Com>,
> KeyStrk_at_Feist.Com wrote:
> > No one does. Oracle doesn't provide a way to turn those pesky extra spaces
 off. (Part of
> > the Unix mentality, I guess.)
> >
> > Two things you can do to mitigate the consequences, though. 1) put an
 extra
 tab at the
> > end. That way all the extra spaces goes into one final column which can be
 deleted once
> > you import it into MS Excel. 2) Find yourself a C programmer that is always
 bragging that
> > C is the only way to go, ask him to 'prove it' by coding a little C program
 that will
> > strip all the extra spaces off the end of a line. If he is any good, it
 should only take
> > him a day or two to code and test it and deliver it to you. (The one I
 goaded
 into this
> > did it in half a day.) Then in your Unix scripts, always have the file
 post-processed by
> > that little C program. I would include the C code here, but it was
 developed using my
> > employers resources, and I need to be faithful to my employer.
> >
> > By the way, when the C programmer then brags that we need to do away with
 Oracle and use C
> > and flat files to do everything, that is when you can spring the news on him
 that Oracle
> > was coded in C.
> >
> > Fabian Bakker wrote:
> >
> > > Hi,
> > >
> > > I want to export data to a ascii, tab delimited file. The linesize is
> > > set to 2000, because the final select statement will have lots more
> > > columns.
> > >
> > > Now I use the following sql script:
> > > SET LINESIZE 2000;
> > > SPOOL C:\OUTPUT.TXT;
> > > SELECT
> > >
> RTRIM(OWNER||CHR(9)||TABLE_NAME||CHR(9)||TABLESPACE_NAME||CHR(9)||RTRIM
 (CLUSTER_
> NAME))
> > >
> > > FROM SYS.ALL_TABLES;
> > > SPOOL OFF;
> > >
> > > The problem with this script is that their are numerous spaces at the
> > > back of each line, Those trailing spaces must be trimmed. I don't know
> > > how to do that.
> > >
> > > Thanx in advance,
> >
> >

>

> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Dec 27 1998 - 00:00:00 CET

Original text of this message