Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - 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

DB Explorer

Code Editor > Toolbox > 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.

TIP:

  • Expand the tree nodes to display the filtered objects.
  • Drag and drop objects from DB Explorer into the Code Editor.
  • Set the behavior of dragging and dropping table names from View | Preferences | Code Editor | SQL Scripts | Drag & Drop.

Describe

Code Editor > Toolbox > Describe

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

Note: To increase response time, the drop down list is not populated with objects when the tool is first activated.

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

Code Editor > Toolbox > 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

Code Editor > Toolbox > Dependencies

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

Note: Objects with a large amount of dependant and depends on objects will take more time to load. To improve the performance, hide this pane when opening those objects.

 

TIP: Right click over the Dependents or Depends On lists to view available commands to manipulate objects in the lists.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating