Toad Data Point 6.2.3

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Record and Play Macros

Use Macros to record a series of keyboard commands in the Editor that can be played back multiple times. This is useful for reducing the amount of manual typing you have to do.

Scenario

You have an INSERT statement with 500 lines of data to insert in the Directors table of the MOVIES database. Before executing the script, a new policy is created to change the order of two columns from LastName, FirstName to FirstName, LastName. Using Macros, you can record the keystroke actions to switch the order of the data values to FirstName and LastName for the first line; and can then press CTRL+SHIFT+P to play the macro and switch the order for the remaining 499 lines.

To create a macro for this example

Place the cursor at the beginning of the first row.
Press CTRL+SHIFT+R to begin recording the macro.
Press CTRL+SHIFT+RIGHT to select the value for LastName in the first row.
Press CTRL+X to remove the LastName.
Press DELETE to remove the comma.
Press END to move to the end of the line.
Press ”,” to add a comma.
Press CTRL+V to paste the LastName after the FirstName.
Press HOME to return to the start of the line.
Press DOWN to move to the next line.
Press CTRL+SHIFT+R to stop recording.
Press CTRL+SHIFT+P to play the macro.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.2.3 - User Guide

Record and Play Macros