Chat now with support
Chat with Support

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

Task Manager

SQL Navigator executes long-running tasks in separate threads in the background. They lock only the current session. Background execution happens automatically, and means that all the application’s functionality remains available to the user while the task is running in a separate session.

The Task Manager is a display of all active and complete tasks for the current session.

The following background tasks can be managed through the Task Manager:

Background Tasks More Information
Batch commands on database objects, such as Drop, Compile, Truncate and Extract DDL Object Menu
Enable Constraint Editor
Execute PL/SQL code PL/SQL Execution Console
View Differences Difference Viewer
Full expansion of a node in DB Navigator DB Navigator
Source Code Search Database Source Code Search
Find Objects Find and Replace

 

Note:

  • Right click on a task to Suspend, Resume, End or Delete.
  • Ending some tasks, such as compiling dependants in a complex table, may appear to "hang." This is due to SQL Navigator waiting for a response from the Oracle server. Even though there may be a delay, control will ultimately be returned to SQL Navigator.

Web Support Configuration Dialog

Specify a local directory where images can be loaded or enter details of your Web server’s configuration.

This is required to view images and follow hyperlinks in your documents.

Wrap Code

The Wrap Code utility provides an easy way to access Oracle’s Wrap Code utility. This window is connection independent so you do not need an open database session to use it.

To wrap code

  1. Click Tools Menu | Wrap Code to open the Wrap Code window.

  2. Input File details:

    Field Description

    Input File

    Enter the file (of PL/SQL code) you want to wrap, including the full path.

    TIP: Click the drill down button to browse for the file.

    Input File Text

    When you have selected the file, the text of the file appears here.

    TIP: Right-click in the text area to copy the code to the clipboard.

    Output File

    By default this is given the same name as the input file, but with extension .plb.

  3. Click Wrap Code.

    Field Description

    Output File Text

    The wrapped code appears in the Output File Text area and is automatically saved to the specified Output File.

    TIP: Right-click in the text area to copy the code to the clipboard.

View | Preferences

| Preferences can be changed by any user and apply to the current user only - unless otherwise stated.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating