When you execute a SELECT statement in Worksheet, the result is displayed in the Result Set. 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 Set is only displayed if you execute a SELECT statement alone and not as a part of a query. |
To switch Result Set to editable mode
|
NOTE: The SELECT statement must satisfy several conditions in order for the Result Set to be editable. Specifically, the statement must not contain:
Additionally, the Result Set 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). |
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 |
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 Grid 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 |
This topic lists all shortcuts that you can use in Toad Edge.
Option | Shortcut |
---|---|
Open SQL Worksheet | CTRL (⌘) + N |
Close | CTRL (⌘) + W |
Close All | CTRL (⌘) + SHIFT + W |
Save | CTRL (⌘) + S |
CTRL (⌘) + P | |
Undo | CTRL (⌘) + Z |
Redo | CTRL (⌘) + Y |
Cut | CTRL (⌘) + X |
Copy | CTRL (⌘) + C |
Paste | CTRL (⌘) + X |
Delete | DELETE |
Select All | CTRL (⌘) + A |
Object Search | CTRL (⌘) + SHIFT + D |
Text Search | CTRL (⌘) + H |
Enable / Disable AutoCommit | CTRL (⌘) + ALT (⌥) + A |
Manage Connections | CTRL (⌘) + ALT (⌥) + C |
New Connection | CTRL (⌘) + ALT (⌥) + N |
Disconnect | CTRL (⌘) + ALT (⌥) + D |
Reconnect | CTRL (⌘) + ALT (⌥) + R |
Preferences | ALT (⌥) + P |
Maximize Window | CTRL (⌘) + M |
Reset Application Layout | ALT (⌥) + SHIFT + L |
Help | F1 |
Open Tab Dropdown Menu | CTRL (⌘) + E |
Next Tab | CTRL (⌘) + F6 |
Previous Tab | CTRL (⌘) + SHIFT + F6 |
Next View | CTRL (⌘) + F7 |
Previous View | CTRL (⌘) + SHIFT + F7 |
Option | Shortcut |
---|---|
Table | ALT (⌥) + SHIFT + T |
View | ALT (⌥) + SHIFT + V |
Procedure | ALT (⌥) + SHIFT + P |
Function | ALT (⌥) + SHIFT + F |
Trigger | ALT (⌥) + SHIFT + R |
Event | ALT (⌥) + SHIFT + E |
User | ALT (⌥) + SHIFT + U |
Database | ALT (⌥) + SHIFT + D |
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 |
Make Code | ALT (⌥) + SHIFT + C |
Strip Code | ALT (⌥) + SHIFT + P |
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 (⌥) + 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 |
Quick Outline | CTRL (⌘) + O |
Toggle Comment | CTRL (⌘) + / |
Content Assist | CTRL (⌘) + SPACE |
Surround with Parentheses | CTRL (⌘) + ALT (⌥) + 1 |
Surround with Brackets | CTRL (⌘) + ALT (⌥) + 2 |
Surround with Braces | CTRL (⌘) + ALT (⌥) + 3 |
Delete Line | CTRL (⌘) + D |
Find Incremental | CTRL (⌘) + J |
Reverse Find Incremental | CTRL (⌘) + SHIFT + J |
Go to Line | CTRL (⌘) + L |
Scroll Line Up | CTRL (⌘) + UP ARROW |
Scroll Line Down | CTRL (⌘) + DOWN ARROW |
Additional context menu | CTRL (⌘) + F10 |
Go to Last Edit Position | CTRL (⌘) + Q |
Move Line Up | ALT (⌥) + UP ARROW |
Move Line Down | ALT (⌥) + DOWN ARROW |
Join Lines | CTRL (⌘) + ALT (⌥) + J |
Object Information (cursor located in an existing object name) | F6 |
Hippie Completion | ALT (⌥) + / |
Option | Shortcut |
---|---|
Insert Row | INSERT |
Delete Selected Row | SHIFT + DELETE |
Apply Changes | SHIFT + ENTER |
Discard Changes | ESC |
Option | Shortcut |
---|---|
Edit Value | ENTER |
Open Value in Editor | CTRL (⌘) + ENTER |
Insert Null | DELETE |
Delete Row | SHIFT + DELETE |
Apply Changes | SHIFT + ENTER |
Restore Original Values | ESC |
Option | Shortcut |
---|---|
Refresh | F5 |
Execute SQL Statement | SHIFT + ENTER |
Run | CTRL (⌘) + R |
Option | Shortcut |
---|---|
Copy Connection | CTRL (⌘) + C |
Reconnect | F5 |
Properties | F2 |
Option | Shortcut |
---|---|
Next Match | CTRL (⌘) + . |
Previous Match | CTRL (⌘) + , |
Remove Selected Matches | DELETE |
By default, every DML (data manipulation language - INSERT, UPDATE, ALTER, DELETE...) transaction is committed immediately by the database. This is the default setting in Toad Edge known as AutoCommit. However, you can also disable AutoCommit for each connection and control the commits manually.
To enable/disable AutoCommit
When you disable AutoCommit, you will have to commit or rollback your transactions manually. Whenever you execute a DML statement in Worksheet or make any modification using Object Detail, the changes will be applied only in your session. They will not be applied in the database unless you commit them.
There are two buttons that can be used to manually control the process:
|
NOTE: These buttons are disabled when AutoCommit is enabled. |
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy