<< Click to Display Table of Contents >>

Viewing and modifying the result set

Top Previous Next

When you execute a SELECT statement with Execute Query, the server produces a result set. Hora shows you the data in a spreadsheet-like form, like the one on the Introduction to SQL Scratchpad. At first, only the first 25 rows are fetched. Every time you scroll to the bottom of the data grid, another 25 rows are fetched. Please note that all the rows will be fetched if you push the Last Last record button. This might take a while, and it requires considerable memory for very large result sets. That's why it is always a good idea to keep result sets small by adding restrictive where conditions to the SQL.

You can make each query updatable in order to edit data within the grid. The only restrictions are

The grid must contain all columns of  the primary key, or of a unique key, or the ROWID.

For a view, you can update only one table's columns at a time.

The view's column names must be the same as the base table's column names.

To get a live result set, you must tell Hora the name of the table to be updated and the key fields for unique record identification. You can select both of them from combo boxes at the top of the tool window. Multiple field names belonging to a composite key should be separated by semicolons. When you press the Apply and request live result set button, the result set becomes updatable.

The changes you make are posted to the server when you navigate out of the cell or press the check mark icon shown in the grid below. You may then commit or roll back the changes by using the orange Commit and Rollback buttons in the main window.  Of course, you may also commit or rollback by entering an explicit command in the SQL code window. If you press the Rollback button, you will see the changes being backed out.

The right mouse button's context menu allows the following operations, some of which are also available from the toolbar above the results grid:


First record

Navigates to the first record.


Prior record

Navigates to the prior record.


Next record

Navigates to the next record.


Last record

Navigates to the last record.


Insert blank row

Inserts an empty record and switches into edit mode.


Insert copy

Inserts a copy of the current record and switches into edit mode.



Deletes the current record.



Switches the current record into edit mode.



Posts the changed record to the database server.



Cancels changes made to the current record.



Shows the entire result set in an editor window. This will enable you to copy a TAB separated multi-column list to the Windows clipboard.


Excel Export

Opens the one-click Excel Export Facility


Export Wizard

Opens the Export Wizard.


Import Wizard

Opens the Import Wizard.


Grid View

For more information, see object window


Initially, the results window is located at the bottom of the page. If you drag its left border away from the form, it becomes a flying tool window that can be moved around the screen and resized. To dock it back to its host window, narrow the window vertically, and drag it towards the bottom of the page until you see a rectangular shadow; then let go of the mouse.

You can also execute SELECT statements using the Execute Script button. In this case, the output is displayed in the DBMS_OUTPUT window. A "no rows selected" message appears if no rows are selected.