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

Set a Breakpoint

  • Single-click in the Editor gutter to set or reset a breakpoint.
  • Press SHIFT+F5 to set or reset a breakpoint on the current line in the Editor.

Set Watches

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.


About Watches

Toad supports watches on implicit and explicit variables, including some complex data types such as explicitly and implicitly defined records, %ROWTYPE records, and cursors.

From the Watches window, you can easily work with your watches. You can select from the toolbars on the window itself, or you can use the right-click menu to access more functions.

Note: You can also hover your mouse over a variable to check the value without formally setting a watch.

To access the Watches window

Click the Watches tab in the Output area.

Note: If the watches tab is not visible, right-click and select Desktop Panels | Watches.

You can right-click a watch and select Export Watches, in addition to other options.

See the online help for more information about using watches.


Add a Watch

To add a watch from the Editor

Note: If the Watches window was not open, you will need to open it to view watches.

  1. Click a variable in the Editor.
  2. Do one of the following:
    • Click image\Icon_-_add_watch.gif in the toolbar.
    • Right-click in the Editor, select Debug and then Add Watch at Cursor.
    • Press CTRL+F5 to add the variable at the cursor to the list of watches. The watch is added but the Watch Properties dialog box does not display.

To add a watch from the Watches window

Right-click and select the Add Watch menu item.

To add a watch from the Debug Menu

  1. Click in the variable you want to watch.

    From the Debug menu, select Add Watch at cursor.

    Note: If text is selected when Add Watch at Cursor is chosen, Toad sets the watch on the selected text. If no text is selected it uses the text under the cursor. This change occurs so that if you have a recordname.fieldname, you can highlight only recordname to set a watch on it. If you have an expression like v_List(2), where v_List is a varray, then you can highlight the entire expression to put a watch on it.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating