Toad sql server run mulitple select statements and write output to file

I forgot to click on the вЂOptionsвЂ¦вЂ™ button to bring up the options available to me. Hmmm, I wanted an actual table name here. This created a text file with insert statements:ДЄs you can see, it inserted a variable of &table_name in my insert statement. You probably get asked to do this frequently.ДЇrom the Export Data options I chose the Table Inserts option and saved it to a file. Now, an interesting feature is the ability to take this output, which came from multiple tables, and create a new table based on this data result set. You can save this data as an HTML file, Excel spreadsheet (even though it says Excel 97-2010, I have been successful with Excel 2016), or XML Spool the text to a file, create a Table Insert statement, and create delimited text.ДЄnd this is an example of an Excel spreadsheet (even though the dropdown says Excel 97-2010 I was able to save this into Excel 2016): There are several options available under the right-mouse button when you are on a data grid:Д¬licking on the вЂExport DataвЂ¦вЂ™ list item will provide you with these options:

When you are writing your queries, either for a new application feature or to gather data for one of your end users, you may need to export that data to a format that the requestor can understand and process.

With SQLNav you can tune your sql statements and debug your PL/SQL (more details on these will come in future blogs. A lot of developers use SQL Navigator (also affectionately known as SQLNav) to write their SQL queries and PL/SQL code.

Toad sql server run mulitple select statements and write output to file