지금 지원 담당자와 채팅
지원 담당자와 채팅

Toad Edge 2.3 - User Guide

Text Search and Search View

Not to be confused with Object Search, Text Search allows you to find specific strings in database scripts of certain object types such as (platform dependent):

  • Aggregates
  • Procedures
  • Functions
  • Events
  • Packages
  • Triggers
  • User types
  • Views and materialized views

To search for specific text in object scripts

  1. Select Database Menu | Text Search or by pressing CTRL + H
  2. Enter the text you want to look for into the Containing text field
  3. The other field, Object name patterns, allows you to search only in objects that match the given pattern
    • For example, "*energy*" will cause the application to only search for text in objects whose names contain "energy"
  4. Select the Databases that you want to search in as well as the Object types
  5. Once finished, click Search. The results will be shown in Text Search

NOTE: You can use standard wildcard characters in both fields mentioned above. Use question mark (?) to match one character, asterisk (*) to match multiple characters and back slash (/) to escape literal characters.

You can also use multiple search patterns in the Object name patterns field as long as you separate them with commas.

Text Search

The results of Text Search are displayed in this window. By double-clicking any match, you can open the respective object in Object Detail and highlight the match.

Button Option Description
Show Next Match Jumps to the next match, automatically displaying it in Object Detail
Show Previous Match Jumps to the previous match, automatically displaying it in Object Detail
Remove Selected Matches Removes the selected matches from the view
Remove All Matches Removes all matches from the view
Expand All Expands all objects and their matches
Collapse All Collapses all matches to their respective objects
Refresh the Current Search Again Performs the current search again
Cancel Current Search Cancels the currently undergoing search
Show Previous Searches Contains a history of past searches that you can perform again

Worksheet and Result

Worksheet is one of the most basic tools in Toad Edge. It is used to interact with a database using SQL scripts and queries. Coupled with additional features such as Content Assist and Outline View, you can create and modify queries in a fast and efficient manner.

NOTE: If you do not specify a database, the scripts and queries will be executed on the Default database (MySQL/MariaDB)

To open a Worksheet

  • Click the Worksheet button on main toolbar to open a blank Worksheet
Worksheet toolbar
Button Option Description
Execute All Statements Executes all statements in the query
Execute From Current Position Executes all statements from the current cursor position in the query
Execute to Current Position Executes all statements up to the current cursor position in the query
Execute SQL Statement Executes the statement where the cursor is currently placed. Can be used to execute multiple selected statements at once
Execute Explain All Displays explain plan cost of all queries
Execute Explain From Displays explain plan cost of all queries from the current one up to the end
Execute Explain To Displays explain plan cost of all queries from the beginning up to the current one
Execute Current Displays explain plan cost of the current SQL query
Cancel Query Stops the query that is currently being executed
Commit Transaction Commits the changes included in the current transaction. See AutoCommitfor more information
Rollback Transaction Cancels the changes included in the current transaction. See AutoCommitfor more information
Select Connection Allows you to select a connection using which the query should be executed
Show Result Set Displays Result Set either in Vertical Layout or Horizontal Layout
Rename SQL tab Opens a dialog where you can enter the new name of the worksheet. This option is disabled for worksheets opened from files.
Worksheet context menu options
Option Description
Revert Restores the last saved state of the Worksheet
Open Opens the selected object in Object Detail. Note that this option only works when you place the cursor in or select a highlighted object name, i.e. an object that already exists in the database
Make Code Statement Generates Java code which recreates the selected query as a StringBuilder object. The code is copied to clipboard
Strip Code Statement When selecting Java code which contains a SQL query, this option will strip away the Java code and keep the SQL code. The code is copied to clipboard
Formatting Provides options to switch the selected text to uppercase/lowercase or to enclose it in text/object quotes
Quick Outline Displays the basic structure of a Worksheet if it contains multiple queries
Toggle Comment Comments out the selected lines
Hint Window

When you hover over a database object name, Hint Window is displayed to provide you with quick information about the object. Hover over the bottom bar of the window to see additional options.

Button Option Description
Open Declaration Opens the object in Object Detail
Show Script Displays the object SQL code in a new Worksheet

Result

When you execute a SELECT statement in Worksheet, the result is displayed in the Result. The rows and cell values here can be conveniently exported to multiple formats and you can even edit the cell values in-place.

NOTE: Currently, the Result is only displayed if you execute a SELECT statement alone and not as a part of a query.

To switch Result to editable mode

  • Select the Result is Editable option in the drop down menu in the bottom-left corner of the Result

NOTE: The SELECT statement must satisfy several conditions in order for the Result to be editable. Specifically, the statement must not contain:

  • Aggregation functions (count, max, sum...)
  • Set operators (join, union...)
  • Nested SELECT statements

Additionally, the Result is not editable when selecting from a view or when the selection does not include at least one identification key column (e.g. primary key).

To navigate and manipulate results

Button Option Description
Go to Beginning Goes to the first page of the Result Set
Go to Previous Page Goes to the previous page of the Result Set
Selected Row Displays the number of the currently selected row
Go to Next Page Goes to the next page of the Result Set
Go to End Goes to the last page of the Result Set
Drop Selected Rows Deletes the selected rows
Apply Changes After editing a value, applies the changes
Restore Original Values After editing a value, cancels the changes
Result context menu options
Option Description
Define in Editor Edits the selected cell value in a type-specific editor
Set Null Sets the selected cell value to null
Export BLOB to file (BLOB columns only) Exports the binary object of the selected cell as a file
Import BLOB from file (BLOB columns only) Imports a file as a binary object and places it into the selected cell
Export Selection Exports the currently selected rows as SQL code or to a CSV/HTML/XML file
Export Query Result Exports the entire result as SQL code or comma separated values

Multiple Result Set

Toad Edge supports working with more than one result sets. Type your SELECT queries into Worksheet and click Execute All Statements. Result sets from all queries will be displayed in a new Result view, where you can easily switch between results, display them side-by-side, edit and export them

To work with multiple results

  • Left-click a result to select it
  • Hold Shift/Ctrl + left-click multiple results to select them

  • Click SQL button to highlight a specific statement in Worksheet
  • Right-click a statement in Result and click copy to copy the statement and later paste it into Worksheet

  • Only a certain number of results will by fetched on execution. Scroll down to reveal more results when one result is selected. Set the number of fetched rows in View | Preferences | Data | Use fetch limit
  • When more result sets are selected, click Fetch More Rows or Fetch All Rows to load more data

To export results

  • Click Export Selected Statements Data to CSV/SQL to export some of the result sets
  • Click Export All Statements Data to CSV/SQL to export all of the result sets

  • Configure destination and format options in the next step:
Feature Description
Export As

Select the desired option:

  • SQL - INSERT statements - exports the data as INSERT SQL statements into the selected destination
  • SQL - MERGE statements - exports the data as MERGE SQL statements into the selected destination
  • CSV - exports the data as comma separated values into the selected destination
Line Terminator

Select from:

  • Environment default
  • Mac/Unix
  • Windows
  • Mac OS Classic
Destination for exported data

Exported data are displayed in:

  • Worksheet - Toad Edge exports the data into a new instance of Worksheet
  • Clipboard - Exports data into system clipboard
  • Single file - Click browse button to select the name for the exported file and its location. All result sets will be saved in one file.
  • Separate files - Click browse button to select the name for the exported file and its location. Files will named automatically.
Compress file in ZIP format Available for exporting as files.
Open directory after finishing the export Opens the destination directory after a successful export.
Format exported queries Check to export data in an easier-to-read format with indentations and extra lines.

 

Keyboard Shortcuts

This topic lists shortcuts that you can use when working Toad Edge.

General shortcuts
Option Shortcut
Open SQL Worksheet CTRL (⌘) + N
Close CTRL (⌘) + W
Close All CTRL (⌘) + SHIFT + W
Save CTRL (⌘) + S
Print CTRL (⌘) + P
Undo CTRL (⌘) + Z
Redo CTRL (⌘) + Y
Cut CTRL (⌘) + X
Copy CTRL (⌘) + C
Paste CTRL (⌘) + V
Delete DELETE
Select All CTRL (⌘) + A
Object Search CTRL (⌘) + SHIFT + D
Text Search CTRL (⌘) + H
Enable / Disable AutoCommit CTRL (⌘) + ALT (OPT) + A
Manage Connections CTRL (⌘) + ALT (OPT) + C
New Connection CTRL (⌘) + ALT (OPT) + N
Disconnect CTRL (⌘) + ALT (OPT) + I
Reconnect CTRL (⌘) + ALT (OPT) + R
Preferences ALT (OPT) + P
Maximize Window CTRL (⌘) + M
Reset Application Layout ALT (OPT) + SHIFT + L
Help F1
Open Tab Dropdown Menu CTRL (⌘) + E
Next Tab CTRL (⌘) + F6
Previous Tab CTRL (⌘) + SHIFT + F6
New object shortcuts
Option Shortcut
Database ALT (OPT) + SHIFT + D
Event ALT (OPT) + SHIFT + E
Function ALT (OPT) + SHIFT + F
Procedure ALT (OPT) + SHIFT + P
Role ALT (OPT) + SHIFT + O
Schema ALT (OPT) + SHIFT + H
Sequence ALT (OPT) + SHIFT + Q
Table ALT (OPT) + SHIFT + T
Trigger ALT (OPT) + SHIFT + R
Trigger Function ALT (OPT) + SHIFT + G
Type ALT (OPT) + SHIFT + Y
User ALT (OPT) + SHIFT + U
View ALT (OPT) + SHIFT + V
Worksheet shortcuts

Use these shortcuts while working with Worksheet. Some of these shortcuts also work in Source of procedures and functions opened in Object Detail.

Option Shortcut
Find and Replace CTRL (⌘) + F
Find Next CTRL (⌘) + K
Find Previous CTRL (⌘) + SHIFT + K
Format Code CTRL (⌘) + SHIFT + F
Open (cursor located in an existing object name) F3
Rename/refactor (cursor located in an existing object name or alias) F2
Add Object Quotation Marks CTRL (⌘) + SHIFT + Q
Add Text Quotation Marks CTRL (⌘) + ALT (OPT) + SHIFT + Q
To Upper Case CTRL (⌘) + SHIFT + X
To Lower Case CTRL (⌘) + SHIFT + Y
Execute All Statements CTRL (⌘) + SHIFT + ENTER
Execute Selected CTRL (⌘) + ENTER
Execute To Current Position CTRL (⌘) + SHIFT + UP ARROW
Execute From Current Position CTRL (⌘) + SHIFT + DOWN ARROW
Toggle Comment CTRL (⌘) + /
Content Assist CTRL + SPACE
Surround with Parentheses CTRL (⌘) + ALT (OPT) + 1
Surround with Brackets CTRL (⌘) + ALT (OPT) + 2
Surround with Braces CTRL (⌘) + ALT (OPT) + 3
Delete Line CTRL (⌘) + D
Go to Line CTRL (⌘) + L
Scroll Line Up CTRL (⌘) + UP ARROW
Scroll Line Down CTRL (⌘) + DOWN ARROW
Additional context menu CTRL (⌘) + F10
Move Line Up ALT (OPT) + UP ARROW
Move Line Down ALT (OPT)  + DOWN ARROW
Object Information (cursor located in an existing object name) F6
Object Detail | Data, Editable Result set
Option Shortcut
Insert Row SHIFT + INSERT
Delete Selected Row SHIFT + DELETE
Apply Changes SHIFT + ENTER
Discard Changes ESC
Edit Value ENTER
Open Value in Editor CTRL (⌘) + E
Insert Null DELETE
Restore Original Values ESC
Lock/Unlock values for editing (Result set) CTRL (⌘) + SHIFT + E
Object Detail | Source (procedures and functions)
Option Shortcut
Refresh F5
Execute SQL Statement SHIFT + ENTER
Run CTRL (⌘) + R
Connections
Option Shortcut
Copy Connection CTRL (⌘) + C
Reconnect F5
Properties F2
Search
Option Shortcut
Next Match CTRL (⌘) + .
Previous Match CTRL (⌘) + ,
Remove Selected Matches DELETE
관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택