Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.
The Object Palette shows all of the objects and their columns in a selected schema. The Object Palette can be docked to the main Toad window, so that it is available within any of your Toad windows, or you can drag it away from its default location to use as a floating palette in a position of your choosing.
When you work in the Editor, you can use the Object Palette as a quick-reference tool to view the objects that you might want to use as you write SQL, rather than opening the Schema Browser for that purpose. You can also drag a table or column name from the Object Palette to Editor.
When the active connection changes the Object Palette automatically refreshes to reflect the new active connection. Or, you can use the refresh button to refresh the list (this method queries the database).
To access the Object Palette
From the View menu, select Object Palette.
To undock and redock the Object Palette
To undock and float the palette to a new location, drag the heading area to the desired position.
To redock the palette, double click the heading area.
In the Object Palette, click . Columns are displayed for the selected object at the bottom of the palette.
Code Completion Templates enable you to store sections of code as a template and then use a keystroke (CTRL+SPACE) to select the named template from a list, which inserts it where your cursor is in the Editor. This feature reduces the amount of time that you spend writing the same code over again.
Code templates are more than a single phrase and can contain line feeds, substitution variables and a cursor position indicator.
entire cursor block (crbl)
CURSOR c1 IS
SELECT | FROM WHERE;
c1rec IS c1%ROWTYPE;
FETCH c1 INTO c1rec;
EXIT WHEN c1%NOTFOUND;
Note: Do not leave spaces between the end of the template description and the final right bracket! NT4.0 API calls to manage profile strings have a bug that will cause reading of the templates file to fail.
To edit or create a Code Template
Toad provides a list of default templates. As you use this feature, however, you can create templates that work better for your purposes, and you may want to edit the default templates or create new ones. You can view and manage Code Templates from the Editor section of the Toad Options. See Code Templates Options in the online help for more information..
To use a Code Completion Template
Type the name of the template (for example crbl) and then press CTRL+SPACE to load the body of the template. If you do not know the name of the template, press CTRL+SPACE to select it from a list. This list is also shown if you type a name that does not exist.
When a template containing substitution variables is selected, you are prompted to enter values. Enter the values in the dialog, then press OK.
If Toad finds a single pipe ( | ) in the template body, it repositions the cursor at that point when the substitution of the template is complete. The pipe is removed, as it is used only as a marker for the cursor position. Only one pipe can be used this way in a code template.