 |
A Handy Tool
Hora's 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. |
|
|
|
Data Import/Export Wizard
Hora comes with a built-in reporting tool. You can start with either filtered data of a table or view, or the result set of a SQL query. After choosing from a bunch of default layout patterns you get a ready-to-print report. It can be saved in a variety of formats including PDF and HTML.
The integrated report designer allows you to apply manual changes that can be saved for later use
|
|
|
|
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.
|
|
|
|
Multiple Window Interface
MDI techniques make Hora 6 easier than ever to use. The window that you choose from the Sidebar can appear alone, or can be tiled with others. For example, you
can execute PL/SQL in one window while looking at table contents in
another. You can also cascade windows to enable fast switching.
|
|
|
|
Oracle
11g Support
Hora helps you to leverage the outstanding new features that come with your Oracle 11g database such as virtual columns, invisible indexes, result cache statistics, read-only tables, XML DB and much more.
|
|
|
|
SQL-Workbench
For each individual 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 an updatable query results grid,
an execution plan, or DBMS_OUTPUT. The SQL Query Builder
can automatically generate SELECT statements from multiple tables or views with the appropriate joins.
|
|
|
|
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 Recording
Hora generates SQL code for every proposed change to the database.
By activating 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 to database objects can be replicated in another database.
|
|
|
|
PL/SQL
Development
Hora supports the development of packages, procedures, functions,
and trigger code. Compiles can be started directly from the editor, and if syntax errors occur, the exact location will be highlighted..
|
|
|
|
Color
Coding of Status
Status information in Hora windows is color-coded, with black denoting a normal state. An object that is not available, or disabled items, are shown in gray.
Red indicates an error, or something that demands attention.
|
|
|
|
Performance Monitor
Inadequate database performance is often caused by improper memory management. Hora shows you several critical cache ratios 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 current and average values do not exceed Oracle's
recommended limits.
|
|
|
|
Users,
Roles and Profiles
You can create and drop users, and assign profiles, roles and privileges to them.
|
|
|
|
Database
Administration
Hora shows the current state of redo log files, SGA, initialization
parameters and library, row and database caches. The percentage of tablespace use is shown
graphically. With Hora, you can create and drop tablespaces and datafiles,
start and stop jobs, start and stop auditing, and define and assign comsumer groups. |
|
 |
 |
 |
|
|
|
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 view the database from the point of view of another schema, 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, LOB's and RAW columns.
|
|
|
|
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 and afterwards. The SQL Query Builder automatically creates join clauses. Foreign-key relationships can be
created or dropped through a graphic interface.
|
|
|
|
| Data Contents Brower
The Data Contents Browser allows quick navigation back and forth between related tables. You can quickly add to or replace a filter for a particular table or view, then filter by selection to see the related rows of master and detail tables.
When you end your session, you can save the Browser settings to an XML file, which will automatically open the Browser with the same filters and tables the next time that you log on
|
|
|
|
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
Using Hora's built-in HTML Documentation Generator, you can generate a description that describes all objects, including PL/SQL objects, in the database. References between objects are shown as hyperlinks. You can 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. |
|
|
