SQL Navigator for Oracle 7.4 - User Guide

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: DB Navigator Find objects Dialog Project Manager 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.