Hora
A Handy Tool Hora is KeepTool's flagship product for viewing and manipulating Oracle databases, and accommodates a variety of users. Primarily designed for both DBA's and developers, it can also make the end user's life easier. Thanks to its intuitive interface and the ability to preview SQL before execution, Hora requires no studying of the manual before jumping in. Its object-oriented navigation system takes you to any database function within a few clicks. Hora is compact. Everything you need to work with the database is in a single tool. Start-up time and resource usage are minimal.
Import/Export Facility Added as part of the upgrade from Version 5 to Version 6, the Import and Export Wizards permit users to import from such formats as Microsoft Excel, DBF, XML, and text; and to export to these formats and to Microsoft Word, PDF, and HTML—just to name a few. In other words, there is no more need to create comma-delimited files as an intermediate step when moving data into or out of the database in order to interface with end users.
Reporting Facility Starting with Version 6, Hora now offers a reporting tool that lets you choose between applying default formatting to tables, views, and query results, or calling on a designer that lets you specify precise formatting and positioning on the page. You can save the format for use at a later time, and you can save the actual report in a variety of formats, including PDF and HTML.
MDI-Technik MDI techniques make Hora 6 easier than ever to use. For example, you can execute PL/SQL in one window while looking at table contents in another.
Oracle 9i Support Hora includes support for 9i features such as dynamic alteration of the SGA, spfiles with comments for changes, automatic segment space management in tablespaces, new data types, new initialization parameters and dictionary views, etc. We will soon be adding support for new Oracle10g features.
SQL-Workbench For each user or workgroup, Hora maintains a list of frequently used SQL commands in the Windows file system. These can be arranged by topic, using a tree structure, and selected for execution at any time. The parser can interpret both SQL commands and PL/SQL blocks. The output window can be used to display such things as query results, an execution plan, or the results of DBMS_OUTPUT. The SQL Query Builder can automatically generate SELECT, INSERT or UPDATE statements.
An Efficient SQL Editor The integrated SQL editor shows syntax through color coding and allows the user to create professional-looking code. Functions such as indentation and commenting of code are built into the editor.
SQL-Preview, SQL-Log Hora generates SQL code for every proposed change to the database. By activating the SQL preview, you can examine the SQL statement and modify it before execution. These SQL instructions can be recorded in a log file. In this way, all changes tested and accepted in a test database can then be imported into production.
PL/SQL Development Hora supports the development of packages, procedures, functions, and triggers. Compiles can be started directly from the editor, with highlighting of syntax errors. Source code can be saved to files, as well as in the database.
Color Coding of Status Status information in Hora windows is color-coded, with black being the standard color. An object that is not available is shown in gray. Red indicates an error, or something that demands attention. Gray is used to show temporarily disabled items, such as key constraints.
Performance Monitor Inadequate database performance is often caused by too many full table scans. Hora shows you the number of full table scans as well as other important system information in graphical form, with a horizontal line indicating the threshold that Oracle has defined as critical. You should make sure that the indicated values do not exceed Oracle's recommended limits.
Users, Roles and Profiles Roles and privileges of are shown for each user. Hora also lets you create and drop users.
Database Administration Hora shows the current state of redo log files, SGA, initialization parameters and cache. The percentage of tablespace use is shown graphically. With Hora, you can create and delete datafiles, start and stop jobs, send data records to pipes and receive them from pipes.
Lock and Session Manager You can use Hora to display all sessions in an instance, their current status, locks that have been requested and acquired, the current SQL instruction, and much more. The lock-wait graph shows you the hierarchy of individual sessions that may be waiting on each other, so that you can easily determine which session may be tying up the database and cancel it if necessary.
Dictionary Browser The integrated data dictionary browser gives you both an object-oriented and relational view of the entire data dictionary's structure and contents.
Access to Schemas You can dynamically access any schema besides your own, as long as you have the required authorization.
Displaying and Updating Data Hora shows you the selected table or view's data in both tabular and record-oriented format. With a single mouse click, data can be sorted by any defined index. You can update, delete, or insert rows. Hora offers an integrated table look-up function using defined relationships, a row-duplication function, and a memo field editor for VARCHAR2 columns greater than 255 bytes. NOT NULL fields are marked as such.
Referential Integrity Hora gives you a relational overview of your database. Diagrams show you the parent/child relationships between tables. Automatic access to lookup tables referenced through foreign keys is available during data entry. The SQL module generator creates SELECT and WHERE clauses from the database automatically. Foreign-key relationships can be created or dropped through a menu option.
Management of Database Objects Virtually all required database objects (tables, views, procedures, sequences, triggers, etc.) can be displayed, created, updated or dropped. You can also rename or drop table columns.
HTML-based Documentation Hora automatically creates documentation for your database in HTML form. This report describes your data model with hypertext links to table descriptions, and between related tables. You can then link Hora's documentation to other project documentation on your intranet.
Generating DDL Scripts Hora generates SQL scripts containing all the DDL needed to create your database, or any object within it.

ER Diagrammer
A Sophisticated Design Tool The Entity Relationship Diagrammer shows the tables and their relationships to each other systematically, following the IDEF1X standard. ER Diagrammer can create an entity-relationship diagram from an existing database. Optionally, for a complex database, ER Diagrammer can generate diagrams for portions that you select. Usually, the result will picture the tables in a manner that clearly shows all relationships. If you prefer, you can rearrange the tables differently, and the connectors will follow along. The graphic can then be saved in a file for future display. You can also use ER Diagrammer in conjunction with Hora, another member of the KeepTool 5 family, to generate a data model for a new database. Simply use Hora to define tables--adding, dropping and renaming columns where necessary; then use ER Diagrammer to create a graphic view of your data model.

PL/SQL Debugger
Indispensable for the Developer KeepTool 5's PL/SQL Debugger gives the PL/SQL developer all he needs to test code. He can set breakpoints and define watches for variables. Breakpoint lines are color-coded and can be removed or reset at will. In addition to the source display, there are separate windows to display watched variables, breakpoints and the call stack. The "Step Over", "Trace Out" and "Run" buttons allow the program's execution to be traced. The values of the variables for which a watch is in effect can be changed. PL/SQL debugger has been designed with the same emphasis on usability as Hora. This insures that both tools are closely integrated. Using Hora and the Debugger together, a developer has everything needed to develop PL/SQL programs successfully and efficiently.