Toad Edge 2.11 - User Guide

Text Search

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

Select Database Menu | Text Search or by pressing CTRL + H
Enter the text you want to look for into the Containing text field
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"
Select the Databases that you want to search in as well as the Object types
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

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 performed 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
	Run All Statements	Runs all statements in the query
	Run From Current Position	Runs all statements from the current cursor position in the query
	Run to Current Position	Runs all statements up to the current cursor position in the query
	Run SQL Statement	Runs the statement where the cursor is currently placed. Can be used to run multiple selected statements at once
	Run Explain All	Runs explain plan cost of all queries
	Run Explain From	Runs explain plan cost of all queries from the current one up to the end
	Run Explain To	Runs explain plan cost of all queries from the beginning up to the current one
	Run Current	Runs explain plan cost of the current SQL query
	Cancel Query	Stops the query that is currently being run
	Commit Transaction	Commits the changes included in the current transaction. See AutoCommit for more information
	Rollback Transaction	Cancels the changes included in the current transaction. See AutoCommit for more information
	Select Connection	Allows you to select a connection using which the query should be run
	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 run 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 run 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
Advanced copy	Gives the option to copy all rows or selected rows with the headers.

Multiple Result Set

Toad Edge supports working with more than one result sets. Type your SELECT queries into Worksheet and click Run 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 upon operation. 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.

Multiple Result Viewers

Toad Edge supports having more than one result view to see query results. Type your SELECT queries into Worksheet and click Run SQL Statement or Run All Statements. If you run your queries multiple times, it will display the results in multiple tabs.

To work with multiple tabs

By default the number of tabs is 1. You can go to View | Preferences | SQL Editor| Maximum results in a worksheet and increase it.
You can at max have 5 unpinned tabs.

To pin a tab

When the maximum number of tabs have already been created, Toad Edge picks the oldest created tab and re-uses it effectively replacing its result. You can pin a tab if you want Toad Edge to retain that tab and the result shown.

Right click on a result tab and click on pin.
Similarly you can unpin a tab.

Button	Option	Description
	Refresh	Manual update of the status of all locks
	Select Connection	Select a PostgreSQL/EDB connection here in order to monitor its sessions
	Resize Columns to Data	Resizes columns so they fit the values they contain
	End Blocking Lock	Ends the Blocking lock
	Copy	Copy the selected lock
	View Menu	Allows you to change the monitoring refresh period

Toad Edge 2.11 - User Guide

Text Search and Search View