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

Toggle Fullscreen Editor

Editor Basics > Toggle Fullscreen Editor

You can expand the Editor to fill the entire screen, hiding all other desktop panes. The fullscreen Editor does not affect windows such as the Object Palette or Code Snippets.

To toggle the Fullscreen Editor

Select Toggle Fullscreen Editor (F2) from the Edit menu.

 

Open and Save Files

Editor Basics > Open and Save Files

The default in Toad's Editor is the standard Windows-style Open and Save File dialogs.

To open a file

Click (Open file) on the Editor toolbar.

To load an object from the database

Click (Load Object from Database) on the Editor toolbar.

To save a file or files

Click one of the following: (Save), (Save As), (Save All Tabs). Files are saved to a selected disk location.

 

Change Current Schema

ALTER SESSION SET current_schema = "USERNAME"

Find text in the Editor

Editor Basics > Find text in the Editor

The Editor provides multiple ways to find what you are looking for in the Editor window.

All of these tools are located under the Search menu on the main Toad Toolbar.

To save the settings as a macro, click in the dialog toolbar.

Command Shortcut Description/Actions
Find CTRL+F

Opens the Find dialog.

Enter a keyword or phrase to search for in the Editor window.

There are options for case sensitive, finding whole words, using Regular Expressions (see Regular Expression Searches), and searching forward or backward in the buffer.

If text is highlighted prior to opening the Find dialog box, that text will be placed into the Text to Find data entry box. If no text is highlighted, then the word at the cursor will be placed in the Text to Find data entry box. The last n find items are available in the drop-down list. They are NOT saved from Toad session to Toad session.

You can also copy other text and paste it into the Find dialog box using CTRL+V.

Find may be available for a window even if the Find button is not present on the toolbar. In these cases, you easily can use CTRL+F from the keyboard to access this feature.

Replace CTRL+R

Opens the Replace dialog, where you can find the keyword or phrase, and then replace it with a different string of text.

When you select Regular Expressions, you can use the Replace with Template option to convert \t, \r, and \n in the text specified in Replace with to a tab, carriage return, and newline, respectively.

Show All None

This command only works after you have performed the Find command. After you use the Find command to search through your text for a word or phrase, you can use Show All to highlight every occurrence of the search phrase. The highlighting is removed with any change to the text in the Editor.

Find Next

 

F3

This item is only enabled after you have performed a Find. It goes to the next occurrence of the text you were searching.

Find Previous SHIFT+F3

This item is only enabled after you have performed a Find. It goes to the previous occurrence of the text you were searching.

Goto Line CTRL+G

If you have a large file, you may want to use this command to move your cursor to a specific line number.

You must enter an integer from 0 to the last line number of the buffer contents.

You can also use bookmarks to quickly navigate around the buffer contents. Use Bookmarks

Find in Files None Finds text in files and supports multiple concurrent searches. Find in Files

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating