Toad World® Forums

Export Multiple Grid Data to Insert Statement

Hello.

I have multiple select statements in a single *.sql file. These sql statements display result in their respective grids. I was wondering if I can export the data of all these grids to INSERT STATEMENT all at once in a single file.

Zubair.

In Toad, think this is hardly possible because Toad grid has only one sql statement (last one).

if you run your script as script (F5) you’ll get text output which is far from out of the box usage.

Last option is to use custom tool (I use it in praxis all the time everyday) that can do export data throught plain sql:

damir-vadas.blogspot.com/…/export-table-to-filecsv.html

With such a file you can then import data through sqlLoader (Oracle) or directly in Excel.

Hope this helps

Damir Vadas

Thanks for your response. Even if I run my select queries as a single scirpt (F5). “Script Output” would display different girds for each query. I can export these grids individaully but thats not what I am looking for.

Zubair.

In Toad, think this is hardly possible because Toad grid has only one sql statement (last one).

I do not see how was I not clear.

Once more-one grid one select stmt.

:slight_smile: