Result Set
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
- Select the Result is Editable option in the drop down menu in the bottom-left corner of the Result Set
|
|
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). |
Result Set toolbar
| 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 Set 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 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 |
Keyboard Shortcuts
This topic lists all shortcuts that you can use in Toad Edge.
General shortcuts
| 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 |
New object shortcuts
| 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 |
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 |
| 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 (⌥) + / |
Object Detail | Data tab
| Option | Shortcut |
|---|---|
| Insert Row | INSERT |
| Delete Selected Row | SHIFT + DELETE |
| Apply Changes | SHIFT + ENTER |
| Discard Changes | ESC |
Editable Result Set
| 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 |
Object Detail | Source tab (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 |
Features
AutoCommit
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
- Double-click the AutoCommit button in the bottom application bar whenever you work with Worksheet or Object Detail
- You can also right-click a connection in the Connections View, select Properties and then (un)check the Enable AutoCommit option
- The last option is to go to the Database menu and select 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:
- Commit Transaction
- the changes you have made will be committed and applied in the database
- Rollback Transaction
- the changes you have made will be discarded and the database will not be modified
|
|
NOTE: These buttons are disabled when AutoCommit is enabled. |