SQL Navigator for Oracle 7.4

Resolved Issues Known Issues System Requirements Product Licensing Getting Started with SQL Navigator 7.4 Globalization Copyright

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.

Bitte w&auml;hlen Sie Ihr Produkt aus:

Damit wir Ihnen besser helfen können, geben Sie den Grund Ihres Chats an:

Empfohlene Lösungen für Ihr Problem

SQL Navigator for Oracle 7.4 - Release Notes