Toad World® Forums

RE: How can I append output on the existing file using export dataset option

I would recommend using Automation Designer for this.

There was a post recently that was very similar to this…

http://www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40644.aspx#40644

From: HanGyo Jung [mailto:bounce-hangyojung@toadworld.com]

Sent: Wednesday, August 14, 2013 3:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] How can I append output on the existing file using export dataset option

How can I append output on the existing file using export
dataset option

Thread created by HanGyo Jung

Hello sir.

I’m using 11.5 version of Toad for Oracle.

I do daily check about 15 databases(more in the future) using Toad with same sql scripts.

I configured Auto Connect on login windows. So when I start Toad I see 15 databases connected on the Connection Bar.

And I open a sql file in the Editor. I do this 15 times on the each databases.

We have a Excel format to make a report. So each database I execute the sql and Copy / Paste from the Output Grid to Excel.

You know what I’m doing and It is too much wasting time.

The Excel Sheet format like this

db1 | data | data | data …

db2 | data | data | data …

db3 | data | data | data …

db4 …

So What I want to do is like below :

Execute a sql on the fist server. Output will be created a csv file.

Execute same sql on the second server. Output will be appended an existing csv file from the above.

Execute same sql on the third server …

What is the best way to minimize typing keyboard or clicking mouse.

Thanks in advance.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.