There are 8 separate queries I need to run and save to individual excel files. What's the best way of running this in toad rather than executing/saving each query?
5
-
write a script to write outputs to files and execute it from SQLPlus command line.Vamsi Prabhala– Vamsi Prabhala2017-09-29 16:23:26 +00:00Commented Sep 29, 2017 at 16:23
-
@VamsiPrabhala i'm still fairly new to toad/sql, how do I do that?lostinOracle– lostinOracle2017-09-29 16:40:50 +00:00Commented Sep 29, 2017 at 16:40
-
1@excelmonkey93 : spool separate ".csv" files for all the queries and use "execute via sqlplus" feature of TOAD. Then open these files and save as excel.Kaushik Nayak– Kaushik Nayak2017-09-29 18:42:14 +00:00Commented Sep 29, 2017 at 18:42
-
I suggest @KaushikNayak's approach. You can follow my answer to a similar question here: stackoverflow.com/questions/15253440/…Marc– Marc2017-09-30 02:29:10 +00:00Commented Sep 30, 2017 at 2:29
-
There's no direct way to export to excel? You need to do .csv then convert to excel?lostinOracle– lostinOracle2017-10-07 22:03:28 +00:00Commented Oct 7, 2017 at 22:03
Add a comment
|
1 Answer
Just figured out how to do this and I'm posting so that anyone else with the same problem can look at this as a possible solution.
Use the Automation Designer feature in TOAD for Oracle. Select export dataset and write in your query that you want exported and into what format you want it exported (I chose excel file). Repeat this process for all your queries. Select all "actions" and run.
