Chat now with support
Chat with Support

Toad for Oracle 12.11 - 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

Use Code Snippets

Work with Code > Write Statements and Scripts > Use Code Snippets

You can create and reuse code snippets in the Editor.

Note: The file associated with these items is located in:

C:\Users\<user>\AppData\Roaming\Quest Software\Toad for Oracle\<version>\User Files\CodeSnippets.dat

To use Code Snippets

  1. From the View menu, select Code Snippets.
  2. Select a category of code from the box at the top of the window.
  3. Select the code from the list. You can:
  4. View a description of the code in the area below the code list
  5. Double-click the code to insert it into the active editor tab
  6. Drag and drop code into the editor

To Edit Code Snippets

  1. From the Toad Options window, select Editor | Code Assist.
  2. In the Code Snippets area, select the category of snippets you want to edit and then click Edit.
  3. Select the snippet you want to edit, and click Edit.
  4. Edit the Oracle Function or the description and click OK.

To Add Code Snippets to an existing category

  1. From the Toad Options window, select Editor | Code Assist.
  2. In the Code Snippets area, select the category of snippets and then click Edit.
  3. Click Add.
  4. Enter the code in the Oracle function box.
  5. Enter a description in the Description box.
  6. Click OK.

To Add Code Snippets to a new category.

  1. From the Toad Options window, select Editor | Code Assist.
  2. In the Code Snippets area, click Add.
  3. Enter a category name in the Category box.
  4. Enter the code in the Oracle function box.
  5. Enter a description in the Description box.
  6. Click OK.

To highlight a snippet

  1. Place your code in the snippet you want to highlight.
  2. From the Editor menu, select Highlight Snippet (CTRL+H).

 

Use a Pick List to Complete Code

Note: There are additional shortcut keys you can use with Toad Insight.See Toad Insight Pick List Shortcuts in the online help for more information.

Use Query Templates

select *

from dba_tables

where owner = <ObjectOwner>

and table_name in <ObjectList>

Format Code

  • Format Case Only,
  • Profile Code, or
  • Formatter Options (opens the Options window).
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating