Save result as insert in a file Toad
<p>I want to save as insert into a file the result of a set of selects (more than 50). I know that I have the possibility to run the select and than export dataset, but that isn't easy for 50+ selects.</p>

<p>I tried with spool: </p>

<pre><code>spool D:\work\selects.sql
select * from names; 
select * from address;
select * from country;
spool off; 
</code></pre>

<p>The problem is that in my file the results aren't saved as insert. I am using Toad. </p>

<p>What can I do?</p>