•	Product Information

Apollo Pro has many features that make the life of the Oracle professional easier.  Apollo Pro will remember usernames and passwords so that opening a new component window is as simple as a single mouse click.  This accessibility does not come at the price of security, however.  Industry standard, powerful encryption protects your vital information, and a program lock feature ensures that no one but you can use the program while you are away from your computer.  An SQL history tracker is integrated into Apollo Pro, to make it easy to store and view past queries.  A password change feature makes it a snap to change your Oracle password on many instances at one time.  Integrated unit testing with PL/Unit increases productivity and reduces errors (Oracle 8.1.6 or better required).

Click the links below to find out more about Apollo Pro's powerful features and what it provides to make the Oracle developer or DBA's life easier.

The SQL Window
The PL/Unit Framework
The Power Tune Window
The Database Navigator
The FTP Client

Each of these components are described in more detail below.  Since Apollo Pro is completely free, you can also just  download the program, and see for yourself just how useful Apollo Pro can be.

	The SQL Window is Apollo Pro's answer to the outdated SQL*Plus application.  This component has the following main features: •   The SQL Window is a powerful PL/SQL editor, not requiring a connection to Oracle.  Write, edit and debug SQL code all from one simple to use yet powerful interface. •   Supports many common SQL*Plus commands, as well as allowing the execution of any DDL or DML statement, singly or in succession •   The output of SELECT statements is shown in a spreadsheet-like grid •   The grid data can be exported to any number of formats, including CSV, tab delimited, or fixed length. •   Apollo Pro will generate ready-to-compile PL/SQL code to perform server side data exports, and table encapsulation packages! •   Substitution and bind variables work just as they do in SQL*Plus. •   Automatic error highlighting makes finding errors in SQL code quick and easy. •   Open and Save files to and from FTP servers. •   Integrated database navigator and file navigator. •   Integrated unit testing framework (Oracle 8.1.6 or better required). •   Many more features!
	PL/Unit is a lightweight and small footprint (one database package) unit testing framework for PL/SQL.  Check out the tutorial to learn more.  Some benefits of unit testing your PL/SQL are: •   Ensure quality of individual procedures and functions. •   Provide a safety net for modifying code long after it is completed, ensuring critical requirements continue to work. •   Provides a sort of coding guide, showing other developers how the code is intended to be used. •   Helps to ensure complete requirements coverage.
	The Power Tune component is your personal, desktop tuning companion.  It gives you the ability to compare the performance of multiple queries at once, and helps you to tune them by providing mouse-click access to Oracle query hints. •   Browse through all Oracle hints, and instantly see a quick description and syntax guide. •   View and compare the execution plan and costs of your different queries. •   Execute the queries and time the retrieval of rows, on the server.  This is important because retrieving rows all the way to the client can be slow and inconsistent, throwing off and possibly invalidating comparisons to other query retrieval times. •   Execute your first query twice, to eliminate the extra cost of Oracle reading the data blocks off of disk.  The second query execution and all further queries will retrieve the necessary data blocks from the DB buffer, thus leveling the playing field.
	The Database Navigator is the perfect compliment to the SQL window.  Sometimes it is necessary for the DBA or developer to modify data, and rather than typing out a tedious insert, update, or delete statement, you can directly view and edit the table or view data in a spreadsheet-like grid.  Other great features include: •   See an overview of tables, view, materialized views, types, sequences, and more!  The over view includes such information as column names and data types, primary and foreign keys, check constraints, and indexes. •   View DDL for any object in the database that you have access to (Oracle 9i or better required). •   Enter in an optional where clause and browse the data in your tables or views. •   Assuming you have the database privileges to do so, update, delete, or insert new records directly.
	The FTP Client is a full featured FTP client that allows the user to upload and download files to and from remote FTP servers, using a familiar and intuitive interface.  Why bother with a command line FTP program when you can do it all from one application? •   Drag and drop uploads and downloads using a Windows Explorer interface. •   Execute custom FTP commands. •   Compatible with all popular FTP server software. •   Create and delete remote directories and files easily. •   Create and store FTP accounts in a strongly encrypted file to give mouse-click access to FTP logins.

Requirements
Version History