Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

SQL Query Results Data Grid

Browse the results of an executed SQL query in a dynamic grid with options for viewing, sorting and navigating. There can be multiple results displayed, one per statement executed. Each result set is displayed in a separate tab.

Note:

  • When a result tab is selected, the SQL query statement that generated the result is focused.
  • If the data is LOB, XML or Array then double click on the data cell for more information. For more information, see Viewers: LOB, XML, Array.
  • The Data Grid supports National Language Support (NLS). Display and edit multi byte data.
  • To display the results of a SQL query as text see SQL Query Log (The Spool Tab).

 

Rows Retrieved

Icon Tool Tip Description
Count Dataset Rows The value appears in bold in the Status bar at the bottom of the Code Editor window.
  Fetch More Retrieve more rows.
  Fetch All Retrieve all rows.
Stop Fetching Use when it takes too long to fetch more/all rows.
Refresh Data Populate the grid with the latest data.

 

Export / Print

Icon Tool Tip Description

Print Data Grid

Print the SQL query results.

TIP:

  • Format the data grid as required for the printed page before you print.
  • To print preview, click the cursor in the data grid and click File | Print Preview.
  • Set printing preferences at View | Preferences |General | Printing.

Export Data

Open the Export Data Dialog.

TIP: Right click on the data grid to select a row or column or the entire data grid. You can copy selected data to the clipboard. There is an option to include the row number or column heading with the copied data.

 

Browse

Icon Tool Tip Description
Top Display the first, previous, next or last record.
Prior Row
Next Row
Bottom

 

Edit (Updateable Queries)

Turn ON Updateable in the SQL Editor Toolbar (Code Editor SQL) before you execute the SQL query. The status panel at the bottom of the Code Editor window says "Updateable" if the results can be edited. It says "Read Only" if the results cannot be edited.

TIP:

  • Press F2, Space or Enter to edit straight from the cell.
  • A calendar opens for a date field (on pressing F2 or Space). Press Space to switch between the Date field and Time field.
  • Double click on the cell if a wider editing space is required.
  • Right click on the data grid for more options.

Requirements

  • The SELECT statement must be a simple SELECT statement (no joins, subqueries in select clause, calculated fields, group by, having, count(), substr or DISTINCT). If you get an error message such as TOKEN:.(12121,2) then your query does not conform to the restrictions for updateable queries.
  • You must have the appropriate privileges to update the table or view.
Icon Tool Tip Description
Add Row Insert a new row before the selected row.

Duplicate Selected Rows

Duplicate the selected row(s).

The duplicated data is highlighted in the grid until it is committed.

Delete Selected Rows Put the cursor on the row you want to delete and click .
Commit Transaction Save new or modified data to the database.
Rollback Transaction Undo changes made to grid.

 

Group Display

To create a group display, right click the data grid and select Group by this column.

Icon Tool Tip Description
Cancel Grouping Cancel the group display.

 

Format

Icon Tool Tip Description

Default/User Defined Column Formatting

User-defined column width. Overrides automatic column width setting. Drag the separators to set column width.

Format Columns By Data Width

Set the column widths to show the widest cell data.

Column names may appear truncated.

Format Columns By Name Width

Set the column widths to show the widest column name.

Table data may appear truncated.

Format Columns By Names And Data

Set the column widths to show the widest column data or column name (whichever is greater).

TIP: The formatted widths are based on the results currently visible. The column widths may change as you scroll down, retrieving new rows. To prevent the column widths from changing when scrolling, Fetch All rows before scrolling.

 

Sort & Display

Icon Tool Tip Description

Grid View

Display multiple rows in a data sheet format

TIP: Click any column header to sort and change the sort options.

Single Row View

Display details of the selected record.

Expand Data Grid

Maximize screen real estate of the data grid.

 

Auto Refresh

Select to refresh the SQL Results Data Grid every (number specified) seconds.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating