Chat now with support
Chat with Support

SQL Navigator for Oracle 7.6 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

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.

SQL Query Log (The Spool Tab)

View a log of executed SQL statements. Retrieve executed SQL statements.

  1. Enable Spool to Screen. For more information, see Code Editor SQL.
  2. Execute the SQL query. For more information, see Code Editor SQL.

  3. Click the Spool tab to view the log.

    TIP: Right click on the log to Select / Copy / Save / Print / Clear the log.

Export Data Dialog

Export the SQL query results

Options Description

Export to:

  • Format -

    • HTML
    • Excel
    • XML
    • Spool Text
    • Table INSERTs
    • Delimited Text
  • Unicode -Select to export the data in unicode format.
  • Open exported file - Select to open the file after it is exported.
  • Clipboard - Select to copy the data to the clipboard for subsequent pasting.

Columns

Select the columns to export.

Rows

Export all records or a specific range. The records can be sorted.

Viewers: LOB, XML, Array

View the contents of a large object (LOB, XML, Array) that is a cell in a table or result of a SQL query. Click on the cell containing the large object.

 

LOB Editor

You can work with the following Oracle8i LOB datatypes.

Datatype

View

Edit
BLOB (binary) Y N
CLOB (character) Y Y
BFILE (external) Y N
NCLOB (multibyte character) Y N

You can use toolbar buttons to perform actions on LOBs. The actions available depend on the LOB and include:

  • Copy to clipboard
  • Save to disk file
  • Save, then view in external application
  • View in preview window
  • Mask or show ASCII values between 128 and 255
  • View BFILE as image or HEX

Note: SQL Navigator does not support working with LOB or Object table columns when using an Oracle 7 client connected to Oracle 8 database. For full functionality, use an Oracle 8 client to connect to an Oracle 8 database.

 

ARRAY Editor

  • Click on +/- to add/remove items in the array.
  • Select any item and click the arrow buttons to reorder the list.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating