Copy Column Names to the Clipboard
You can copy the names of selected columns in the data grid to the clipboard. The names are copied in the order they are listed in the grid, for use in WHERE clauses or other tasks where you need a list of column names.
To copy column names
- In the data grid, click
(column selector) in the grid header, then select the columns that you want to copy.
- Select the sort order (alphabetical or grid order, the default).
- Right-click the selected column list, then select Copy checked columns to clipboard.
Work with Data
Throughout Toad, information is presented in a grid format. Within grids, you can customize grid views, filter result sets, print the grid contents, and other standard operations. Grids that provide query results have additional functionality. In most data grids you can edit data, perform calculations on grid cells, and sort and group data, among many other things.
Understand Editable Resultsets
A data grid is fully editable providing that the query itself returns a resultset that can be updated. Query statements must return the ROWID to be editable. For example:
Not editable:
select * from employee
Editable:
select employee.*, rowid from employee
Notes:
- You can substitute EDIT for SELECT * FROM. Toad translates it into the editable version of the statement. For example, edit employee returns the same result as select employee.*, rowid from employee.
- If the resultset should be editable but remains read only, make sure the Use read-only queries checkbox is not selected on View | Toad Options | Data Grids | Data options page.
Copy Data to Another Schema
You can quickly copy data from one or multiple tables to the same table or tables in another schema or database. Toad builds insert statements that use array binding in the variables to copy the data, or if you prefer, create masked data. If you set the array size to 500, then 500 rows are inserted with a single insert statement. The array size is adjustable.
Note: Toad copies data from one schema to another between tables that have the same table name. The tables must exist prior to running this command.
To copy data to another schema
-
Do one of the following:
- In the Schema Browser, right-click one or more tables, then select Copy data to another schema.
- On the Import/Export tab of the Automation Designer, double-click
(Copy Table Data) to add the action to your app, then double-click the action to open the Properties dialog.
- Choose from the menu.
- Use the Source/Dest and Options tab to select destination connection, schema, and options.
-
Use the Tables, Where Clauses, Data Masking tab to select tables, add and test a WHERE clause, and specify data masking.
Tip: You can check your WHERE clauses by clicking 
(Test Where Clauses).
