CODEWITHSUNDEEP
oracle-databaseexporttoad
aherrick
aherrick

Reputation: 20169

TOAD Export Oracle Script To Save Data Programatically

I have a bunch of SELECT statement scripts where I am pulling data for a bunch of different tables. As far as exporting that data and saving it, I have to manually run each query, right click and "Save Data As" select my options, then click save.

Is there any thing I can wrap my SELECT statment programatically in so that when I run it it will automatically export and save the data eliminating the need for me to manually "Save Data As?"

alt text

Upvotes: 1

Views: 11065

Answers (2)

Medezark
Medezark

Reputation: 11

yes, you can. Toad has an automation designer that will allow you to automate and schedule the task. Look under Utilities -- Automation Designer.

Upvotes: 1

vls
vls

Reputation: 2319

Most straightforward way to accomplish what you're trying to do is to use sqlplus to spool results of your select queries into a csv file.

See this stackoverflow answer for directions:

How do I spool to a CSV formatted file using SQLPLUS?

Upvotes: 0

Related Questions