Toad Data Point 6.4 - User Guide

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 Create Databricks 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 Set Bind Variables Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries Publish Data to Intelligence Central

About Publishing Data Prepare to Publish Data Publish to Intelligence Central Specify a Destination Database Specify Default Variable Value Considerations and Limitations Publishing from Excel / Local Storage Troubleshooting

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

How to configure Toad to use Auth for sending SMTP Emails

Automatically Replace SQL

You can instruct Toad to automatically replace misspelled words or to replace a placeholder word with a phrase or statement when entering SQL in the Editor. This is done by setting up Auto-replace templates through the Options dialog.

Go to Tools | Options | Editor | Auto-replace to create Auto-replace templates. See Auto-Replace Options for more information.

Examples of what you can do with Auto-replace templates

If you specify a substitution pair of teh = the , when you type teh in the Editor, Toad automatically changes it to the after you press SPACE.
If you specify a substitution pair of NDF = NO_DATA_FOUND, when you type NDF in the Editor, Toad automatically replaces it with NO_DATA_FOUND after you press SPACE.

Tip: Toad provides built-in functions (Toad Script) that can be used in SQL scripts in the Editor. Some can used with variables to specify keywords or identifiers in statements. See About Toad Script for more information.

Please select your product:

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

Recommended Solutions for Your Problem

Toad Data Point 6.4 - User Guide

Automatically Replace SQL