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

Extract DDL | Constraints

| Constraints

Constraints

Option Description
Include ON DELETE SET NULL clause Includes the ON DELETE SET NULL clause in the DDL.

Extract DDL | Materialized Views/Snapshots

| Materialized Views/Snapshots

Materialized Views/Snapshots

Option Description
Include BUILD clause Choose the type of build clause used for snapshots.

Extract DDL | Users

| Users

Users

Option Description
Include encrypted password Select to include the user's password (encrypted) in the extract ddl script.

Project Manager

View | Preferences > Project Manager
Option Description
Hide inactive project windows Only display the selected Project Manager window.
Hide Project Manager after connecting Once a connection has been made successfully, close the Project Manager window.
Remember Oracle Home/Client for each connection Displays the Home/Client column. Remembers the Oracle client for each connection and automatically connects the next time the item is opened (if the connection is closed).

Auto add items to Project Manager

Option Description

On Connect

Once a connection has been made successfully, add the connection to the Project Manager.

Direct connections are not added to the Project Manager.

On Create/Open object Once an object has been created or opened it is added to the Project Manager Window.
On Create/Open file Once a file has been created or opened it is added to the Project Manager window.
On Browse/Edit Data If the user browses data in a table, then the table is added to the Project Manager Window.
On Describe object If the user chooses to describe an object, then the object is added to the Project Manager Window.
On Execute object If the user executes a procedure or function, then that object is added to the Project Manager Window.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating