Chat now with support
Chat with Support

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

Working With Objects

When you select an object, SQL Navigator enables all the appropriate menu or toolbar commands. The available actions vary depending upon the type of object selected.

Icon Tool Description

DB Navigator

Double click on an object to open it for editing.

TIP: Another way to open an object for editing - drag the object from:

Drop the object on the application desktop.

Describe

The Oracle DESCRIBE command reports the attributes, methods and arguments of an object type. With the SQL Navigator Describe command you can describe not only procedures, functions, packages, synonyms, and object types, but also tables, indexes, clusters and objects.

Visual Object Editors

SQL Navigator editing tools for database objects.

Code Editor

Maintain SQL and PL/SQL code.

Execute SQL queries. Debug PL/SQL code, prepare test data, run stored programs against the database, and immediately view the results. Compilation errors are precisely highlighted.

Quick Browse

View chained rows information.

Edit Data

 

Edit data in a table object.

It is possible to display and edit multi byte data. National Language Support can be applied to data in the Table Editor and Code Editor | Data Grid (SQL Query Results Data Grid).

 

Copy an object from one schema to another

  1. Open a second DB Navigator window.
  2. Drag the object from the source window to the target window.
  3. Execute the DDL displayed in the editing window

Web Development

The SQL Navigator Web Development module provides an integrated development environment with advanced coding, testing, and viewing of PL/SQL programs for the Oracle Web server. This allows users to develop the PL/SQL code independent of the web server and view the HTML in an integrated web browser, thereby eliminating the need to switch from their coding environment to an external browser. The stored procedure will output the HTML code via the Oracle Web Cartridge.

Icon Tool Description
Capture Web Output Enable the web server. Each time you execute PL/SQL code, the generated HTML is displayed in the HTML viewer.
Web Support Configuration Dialog Enter details of your Web server’s configuration.
Code Editor Code Web Server Procedures. The editor includes drag and drop coding for Web toolkit packages, including htp and htf items. Execute the procedure.
HTML Viewer View HTML pages.
Import HTML as PL/SQL Convert a HTML file into a PL/SQL stored procedure.

Java Source Code

Icon Tool Description

DB Navigator

View Java-related objects (sources, classes, resources)

Database Source Code Search

Java Editor

Edit Java source stored in the database.

Compile Java objects

Object Menu | Extract DDL

Extract SQL DDL of Java Source

Java Manager

Load Java classes (Oracle LoadJava utility)

Drop Java classes (Oracle DropJava utility)

Publish Java to PL/SQL

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

Analysis And Tuning

SQL Navigator provides useful tools for tuning and database management. These tools are intended to be used in conjunction with each other.

Icon Tool Description
Analyze Tool View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes.
Explain Plan Tool Analyze the execution of a single SQL statement. By examining the execution plan, you can see exactly how Oracle executes your SQL statement, and how it can be improved.
ER Diagram Model a table and graphically see the dependencies and joins to other tables.
Code Road Map Display the complex PL/SQL inter-dependencies within a database.
Integration with Benchmark Factory Benchmark Factory® is a highly scalable load testing, capacity planning and performance tuning tool capable of simulating thousands of users accessing your database, file, Internet and messaging servers.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating