Toad World® Forums

Beta Released (12.9.0.37)

Beta Notes
Export Dataset

  • New export format: Select Statements (from dual) - Creates a select statement from dual (or multiple select statements from dual, UNION ALL’d together) so you can reproduce a particular dataset from a query without the original tables.

  • If exporting from a grid and you have selected a certain range of columns, you can now right-click on the “Columns to Exclude” dropdown and choose “Include only selected columns”. This will cause all non-selected columns to be excluded from the export. (Note, there is already a checkbox to export only selected rows)
    Grid -> Single Column Export
    New features in Single Column Export:

  • Option to export selected rows only

  • Option to export to single file or clipboard

  • Various format options in single file / clipboard mode, including the ability to export data as an “In” list for use in SQL.