DB Navigator shows the entire database structure as a tree with expandable nodes.
Icon | Tool Tip | Description | ||
---|---|---|---|---|
|
Back and Forward |
Retrace your steps. Navigate between hyperlinked database objects and their dependent objects and components. Move between—
You can also use the Forward and Back buttons in conjunction with Up One Level. | ||
Up One Level |
Change hierarchy levels in the DB Navigator tree.
| |||
DB Navigator Preferences |
Set and Save filters to limit the objects displayed in the tree. Open the Filter Properties Dialog. | |||
Fully Expand Node from DB | Expand the selected DB Navigator node and all its descendants. | |||
Refresh from Current Node | Refresh the selected DB Navigator node. | |||
Show/Hide Details Panel |
Show / Hide details about the selected DB Navigator node.
|
DB Navigator displays all types of Oracle objects, giving you a hierarchical view of any schema, including dependent objects. The tree view includes nodes for "My Schema," "All Schemas," and "Current Instance."
This symbol |
Indicates |
---|---|
The node can be expanded. Click + to drill down to underlying objects or data. Alternatively, press the right arrow key or the space bar while the node is selected. | |
The node can be collapsed. Click the – sign. Alternatively, press the left arrow key while the node is selected. | |
(Grayed text) |
The database object at that node is disabled or offline. |
(Red text) |
The database object at that node is invalid. |
|
TIP:
|
Create or modify DB Navigator filters that restrict the display of objects in the DB Navigator tree. You can save your filters, so that they will be available from the DB Navigator toolbar.
Field | Description |
---|---|
Filter Name | Select an existing filter name or enter a new one. |
Tab | Description |
---|---|
General | Selected schemas will be visible in the DB Navigator tree when the filter is applied. |
Global Filters | Selected top level nodes will be visible in DB Navigator when the filter is applied. |
Object Filters |
Selected object types will be visible in the DB Navigator window when the filter is applied. Application of name masks Type the name mask in the Filter box.
|
The Oracle DESCRIBE command reports the attributes, methods and arguments of an object type. The SQL Navigator Describe command works with more objects than does the SQL*Plus version of the command. You can describe not only procedures, functions, packages, synonyms, and object types, but also tables, indexes, clusters and objects.
To open the Describe window
| |
DB Navigator | Right click the object in DB Navigator and select Describe. |
Project Manager | Right click the object in Project Manager and select Describe. |
Code Editor | Right click the object in Code Editor and select Describe Object at Cursor. |
Shortcut | Ctrl+F3 |
|
TIP: To keep the existing Describe window open while opening additional Describe windows, click the Pin toolbar icon in the Describe window. Set the default pin behavior in View | Preferences | General | User Interface.
|
Tips to use the Describe window
A quick way to construct a SELECT statement |
To drag column names into the Select statement
|
Describe Command or Auto Describe Tool
Use either the Describe command or the Auto Describe Tool to describe an object
Auto Describe Tool |
Automatically see a description of any object you select. A dockable Describe window opens and stays on top of the application window. As you select various objects you will automatically see a description of the selected object in the Auto Describe window. |
Object | Describe |
Click the Describe command on the Object menu whenever needed. It opens a describe window for a single selected object and will not update automatically when you select another object. |
The Difference Viewer displays the compared objects in a split window. Differences between the objects are highlighted, and the toolbars and menus give you access to controls for customizing the view and creating reports.
Icon | Tool Tip | Description |
---|---|---|
Reload and recompare files | Reload the external SQL/text files. Recompare. | |
Open files | Open an external SQL/text file. | |
Save | Save to an external SQL/text file. | |
Switch sides | Switch left and right sides. | |
Find Previous Difference | Go to the previous difference. | |
Find Next Difference | Go to the next difference. | |
Show All | Show all lines of the compared objects. | |
Just Show Differences | Show only lines with differences. | |
Just show major differences | Show only lines with major differences (as defined by File Comparison Rules). | |
Just show matching lines | Show only matching lines. | |
Find | Find a text string. | |
Find again | Find the next occurrence of the text string. | |
Go to line number | Go to a specific line number. | |
Copy To Right | Replace the selected line (right) with the selected line (left). | |
Copy To Left | Replace the selected line (left) with the selected line (right). | |
Delete left text | Delete the selected line (left). | |
Delete right text | Delete the selected line (right). | |
Undo | Undo the change made to the selected line. | |
Produce file differences report | Generate a report of differences. | |
Comparison summary | Compare similarities and differences in a summary. | |
Show whitespace | Show/Hide space characters as tilde (~) characters. | |
Show line numbers | Show/Hide line numbers. | |
Show thumbnail view |
Show/Hide thumbnail view. The thumbnail view (to the left of the viewing window) is a visual summary of differences. Colored lines show the relative position of line mismatches. A white rectangle represents the part of the text currently visible in the Difference Viewer window. You can click on the thumbnail view to position the viewer at that point. Use to quickly change locations within the viewing window. | |
Show line details | Show full details of the current line below the viewing window (so you don’t have to scroll to see the entire line) | |
File comparison rules | Open File Comparison Rules. | |
Options | Open Viewer Options. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center