Hi Thomas-
Pretty interested in your method!! I tried it out but I guess I have to
create the WTW_JOB_NOTIFY table and populate it and I can't figure where the
mail notification is used. Assit with the table structure and an explanation
on how this table is used.
Thanks and Cheers,
CSW Simon.
--
] [mailto:[EMAIL PROTECTED] Sent:
Wednesday, January 21, 2004 8:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Spool to Excel
File> If you
use tab separated columns, you can also generate formula's that look like
text, but work just fine in the spreadsheet! Didn
kbook.
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/20/2004 12:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Spoo
"SYLK allows cell references, etc, if needed, which you won't get
with CSV.
"
Ahh. but you can with my method! If you use
tab separated columns, you can also generate formula's that look like text, but
work just fine in the spreadsheet!
Tom Mercadante Oracle Certified Professional
Strange, no one has mentioned OWA_SYLK.
Do a search on SYLK at asktom.oracle.com
There are 2 versions, one for web output and one for excel output.
SYLK allows cell references, etc, if needed, which you won't get with CSV.
Jared
"Mudhalvan, Moovarkku" <[EMAIL PROTECTED]>
Sent by: [EMAI
MAIL PROTECTED]>
c.com> cc:
Sent by: Subject: Re: Spool to
Excel File
[EMAIL PROTECTED]
.com
t
ORACLE-L <[EMAIL PROTECTED]>
c.com> cc:
Sent by: Subject: Re:
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/
With that you could slurp data out via DBI, and then build a customized spreadsheet
based on the data.
But I'd agree with what others have said. Dumping to csv
Mudhalvan,
I generate files that excel can open all the time. they are not actual
"real" excel files, but Excel can deal with them quite easily.
Here is a tablespace report I run every week. Note the use of the CHR(9)'s.
This is a TAB character. This forces each column into a new cell in the
s
[EMAIL PROTECTED] On
> Behalf Of Mark Richard
> Sent: 20 January 2004 05:14
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Spool to Excel File
>
>
>
>
>
>
> Hi,
>
> You won't be able to write an Excel format directly but you
> can
Hi,
Years ago, I stole this idea from:
http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm
I've used it a few times, mostly to impress
bystanders. It's got size limitations, but kinda cool
anyhow.
Getting SQL Query Results into an Excel Spread Sheet
By Pavel Luzanov
This months sc
Try with
spool c:\Program*Files\Microsoft*Office\Office\excel.exe
On 2004.01.19 23:44, "Mudhalvan, Moovarkku" wrote:
> Dear Friends,
>
> I am trying to send output from SQLPlus to Excel file. If any
> one did the same before please let me know.
>
> Thank You
>
> Mudhalvan M.M
> --
Hi,
You won't be able to write an Excel format directly but you can create a
.csv file, which Excel will happily read in - you'll just have no real
formatting options.
Look into some of the sql*plus commands like "set heading off", "set verify
off", "set feedback off", "set pages 0", "set lin
13 matches
Mail list logo