Home » SQL & PL/SQL » Client Tools » DATA EXPORT To EXCEL (TOAD 9.7.2.5,TOAD DATA ANALYST 2.1.0.227)
DATA EXPORT To EXCEL [message #592219] Mon, 05 August 2013 12:34 Go to next message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Hi,

I have a specific requirement.
Currently in our system a SQL script is automated trough TOAD DATA ANALYST (Contains 50 sql Select statement) and all the output are stored in a single excel file in multiple worksheet. All these sql statements are running sequentially. Now my requirement is

1) All the sql queries will be executed in database in parallel .

2) All the output of select statement will be stored in a single excel.

3) Idea using any Client is appreciated but Toad is preferred.


Please let me know if you need further input on this.
Thanks,
Himadri.
Re: DATA EXPORT To EXCEL [message #592221 is a reply to message #592219] Mon, 05 August 2013 12:40 Go to previous message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
It takes 1 woman 9 months to produce 1 baby.
Now you want to use 9 women to produce 1 baby in 1 month.
It likely won't happen; regardless of any such "requirements".
Post single reproducible test case where more than 1 session can write to single excel file concurrently.
Previous Topic: How to handle errors in sql files by SQLPlus
Next Topic: SQL PLUS Crashes
Goto Forum:
  


Current Time: Fri Sep 19 03:36:56 CDT 2014

Total time taken to generate the page: 0.12538 seconds