When copying table data to another table you can select a subset of source table columns from which to copy.
Only data in the selected columns will be copied to the destination table. Copy Table Data is accessible from the
Schema Browser Tables view right-click menu (Data | Copy to another schema).
Note: Copy Table Data is also accessible from the Automation Designer (Utilities | Automation Designer).
Note: Import Table Data is also accessible from the Automation Designer (Utilities | Automation Designer).
Automation Designer
If the dataset is a SQL file containing multiple SELECT statements, Toad will generate one file per statement. If the destination is Excel File then Toad will generate a new sheet per statement. Similarly, if the dataset is SQL text then multiple SELECT statements results in multiple files.
Support for multiple variable values per line, separated by a delimiter of your choosing. Values are referenced within child actions using the fully qualified variable name which is the action name and the 1-based value index, e.g. %MyFileIterator.1%
Schema Browser
Row Select option added to right-click menu. Row Select is enabled, by default.
Generate Schema Script (Database | Export | Generate Schema Script) has added support for ANALYTIC VIEW, ATTRIBUTE DIMENSION, HIERARCHY, and INMEMORY JOIN GROUP object types.
Toad® Script Runner
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center