Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Create a Find and Replace Macro

Toad enables you to create Find-and-Replace Macros that enables you to quickly perform find-and-replace tasks that you perform often.

To create a Find and Replace Macro

The following is an example of how to create a Find and Replace Macro. In this example, you frequently need to select a few Product IDs from a large table and perform a query on them to make the data more manageable. To accomplish this, you copy the IDs and paste them in the Editor. Then, you create two Find and Replace macros. The first macro wraps the pasted IDs in quotes. The second macro removes newlines and converts them to a comma separated list.

  1. Copy the Product IDs from the table, then paste them in the Editor.

  2. Create the first macro:
    1. Click CTRL+R.

    2. Complete the fields in the Replace window to wrap the IDs in quotes.

    3. Click and name the macro WrapInQuotes. Click OK.
    4. Click Replace All in the Replace window. Toad runs the macro against the Editor.

  3. Create the second macro:
    1. Click CTRL+R.

    2. Complete the fields in the Replace window to create a comma separated list.

    3. Click and name the macro CommaSeparatedList. Click OK.
    4. Click Replace All in the Replace window. Toad runs the macro against the Editor.

  4. Use the new comma separated list to query the IDs.
  5. To reuse these macros in the future, click the down arrow next to the (Replace Text) button in the Edit toolbar. Run the WrapInQuotes macro first and then the CommaSeparatedList macro.

 

Use Bookmarks

Note: The # must be called from the number row on the keyboard. Using the Number pad will not call the bookmark.

Find in Files

The Find in Files dialog supports multiple concurrent searches. When you select a result, a preview window displays and stays on top so you can easily compare other results.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To find in files

  1. Select Search | Find in files.
  2. Enter the text you want to find in the Search for field.
  3. Enter the types of files you want to find in the File mask box. For example, *.* searches for all files and *.txt searches for all text files. You can search for multiple file types and separate them with a semicolon, such as *.sql;*.txt (searches for all .sql and .txt files).

  4. Select options in the Find in Files toolbar to include additional search criteria, such as searching sub-folders and using regular expressions.
  5. Click .
  6. Double-click a file in the results to preview it. The preview window stays on top so you can easily compare other results.

 

Move Between Editor Tabs

  • Click the tab you want to open.
  • Press ALT+PageUp or ALT+PageDown to cycle through them.
  • If you have opened them using the CTRL+Click functionality within the Editor, click the navigation buttons in the Editor toolbar and select either scroll forward and back through them in the order they were opened, or select from a drop-down order.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating