Chat now with support
Chat with Support

Toad Edge 1.1 - User Guide

Result Set

User Interface > Worksheet and Result Set > 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:

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

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

User Interface > 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
Print 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

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating