SQL Navigator for Oracle 7.6 - User Guide

DB Explorer

Find and open objects.

Icon	Tool Tip	Description
	Refresh	Refresh the tree data. Use if you have created new objects that are not visible in the tree yet.
	Name Filter	Type in a filter phrase (for example c% to filter all objects with names starting with c).
	Upper case filter	Click to toggle between Upper case filter and Mixed case filter. The upper case filter is selected by default. Use the mixed case filter to find objects with names that are mixed case, lower case or have special characters.
	Filter	Open the Filter Properties dialog. Filter Properties Dialog

DB Explorer is similar appearance to DB Navigator. DB Explorer is a light version of DB Navigator, integrated into the Code Editor for extra convenience.

Describe

Show the data structure for tables, indexes, views and synonyms.

Icon	Tool Tip	Description
	Filter	To show the complete list, leave the Filter blank and press Enter. You can use wildcards to filter the objects. For example, type t% and press Enter to display only objects with names starting with "t". Select an object from the list to show its column names and types.
	Quick Browse	View the chained rows information as per Object Menu | Quick Browse. Select the object to Describe. The results show in SQL Query Results Data Grid.
	Edit Data	Edit data in a table object as per Object Menu | Edit Data. Select the object to Describe. The results show in SQL Query Results Data Grid. The Edit Data command executes an Updateable query.

History

The History tool lists successfully executed SELECT, UPDATE, DELETE commands and PL/SQL blocks up to 1000 of the most recent ones in the current session. In the History window, each SQL statement is accompanied with the date, time and the schema that they were executed on.

You can easily recall the most recent SQL statements that have been executed in the current session.

1. Select the statement you want to recall.

   TIP: You can press Ctrl+up arrow to move back in the sequence, and Ctrl + down arrow to move forward.

2. Take action.

   Button	Description
   New Tab	Open a new Code Editor tab and paste the statement into it.
   Insert	Add the recalled statement to the current contents.
   Replace	Replace the current contents of the editing window with the selected SQL statement.
   Clipboard	Copy the statement to the clipboard, ready to paste the statement into another location.
   Delete	Drop the statement from the SQL History list.
   Double Click...	Select an action (New Tab, Insert, Replace or Clipboard) that will be executed on double-clicking an entry in History.

    

   TIP: You can also insert the statements by dragging and dropping them into the Code Editor.

Dependencies

Lists the Dependants and Depends On objects of the current script.