SQL Navigator for Oracle 7.5 - Release 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.

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.

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.

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).

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 Topics

Open From: Code Editor | New SQL, Quick Browse, Edit Data.

See also: Code Editor SQL, Edit, Compile And Execute, SQL Query Log (The Spool Tab)

SQL Navigator Preferences: View | Preferences | General | User Interface