1

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

Improve this question
2
  • How are you saving the exported data ? SQL statements ? CSV ? Commented Dec 7, 2010 at 16:06
  • I am saving the data just as a pipe deliminted flat file .txt Commented Dec 7, 2010 at 16:40

2 Answers 2

Reset to default
1

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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?

Improve this answer

2 Comments

Thanks for your answer. However, I do not have access to sqlplus currently. Is this possible to be done with just TOAD?
aherrick: sqlplus is distributed with oracle clients, you can download them from oracle. Since you're already using TOAD which needs an oracle client to connect to the database, you should be able to use sqlplus as well. There is no way to do this in TOAD for a number of queries automatically.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.