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

Publish Java to PL/SQL

Create a PL/SQL package from a Java class stored in the database.

  1. Select a Java Class stored in the database. Use DB Navigator or the Find objects Dialog.
  2. Click Object | Publish Java to PL/SQL.
  3. Follow the prompts to generate a PL/SQL package that stores the procedures and functions used to call Java methods for handling the stored object.
  4. The package is generated and displayed in the window. Do you want to open it for editing before saving it to the database, or save it as shown?

Quick Browse

View chained rows information.

  1. Select the table object.
  2. Click Object | Quick Browse.
  3. The Code Editor opens. The query is run. For more information, see SQL Query Results Data Grid.

Rename Object

  1. Select the object.
  2. Click Object | Rename.

Search Knowledge Xpert

Drag and drop optimized routines directly into your program editor.

Knowledge Xpert is a library of more than 900 pre-built PL/SQL routines, written by some of the world's leading PL/SQL experts, that can be integrated into the standard PL/SQL environment. The complete PL/SQL Code Library can eliminate hours of low-level coding and debugging while enhancing application performance and reliability.

 

Knowledge Xpert

SQL Navigator users can now access 5,400 technical topics, error messages, pre-built and tested code solutions, and code formatting technology. Using the Code Assistant, you can drag and drop these optimized routines directly into your program editor.

For example:

  • Knowledge Xpert for Oracle Administration A complete and essential resource for Oracle DBAs.
  • Knowledge Xpert for PL/SQL Comprehensive PL/SQL knowledge combined with an extensive PL/SQL code library.

TIP: Knowledge Xpert add-on modules are available directly from your Quest Software representative.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating