Text Search and Search View
User Interface > Text Search and Search View
Worksheet and Result
User Interface > Worksheet and Editor
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:
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
User Interface > Keyboard Shortcuts
This topic lists shortcuts that you can use when working Toad Edge.
General shortcuts
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
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.
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
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)
Refresh |
F5 |
Execute SQL Statement |
SHIFT + ENTER |
Run |
CTRL (⌘) + R |
Connections
Copy Connection |
CTRL (⌘) + C |
Reconnect |
F5 |
Properties |
F2 |
Search
Next Match |
CTRL (⌘) + . |
Previous Match |
CTRL (⌘) + , |
Remove Selected Matches |
DELETE |