Home » Other » 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.

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

Previous Topic: How to handle errors in sql files by SQLPlus
Next Topic: SQL PLUS Crashes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 21 04:54:41 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.