Hora is a compact and extremely powerful program. The consistent user guidance makes it a pleasure to work with. Hora covers everything you need for your daily work. For example:
Database objects such as tables, triggers, sequences, pipes, etc. can be displayed, stored or deleted.
Data contents of tables and views can be filtered, displayed and edited.
Freely definable and pre-defined reports.
Convenient data navigation.
Link to Visual SourceSafe.
Rapid access to the Oracle documentation.
Database sessions can be colour-coded or marked with a logo or bitmap.
PL/SQL and Java methods can be edited and compiled.
SQL commands can be administered and executed.
Powerful SQL query builder.
Export and import of table data, in accordance with Excel(and many other formats)
Administering database sessions.
Database parameters can be displayed and changed, performance can bevisualised.
We know that working with Oracle databases requires qualified experts. Our job, as we see it, is to present you all the information as clearly and conveniently as possible. That was always one of the strong points of our software. Hora represents a major step forward in this process.
Getting there quicker …
Hora’s navigation system is unique among Oracle tools. You can access every part of your database simply by choosing from the sidebar, clicking a tab register, scrolling, or filtering.
Displaying and changing data
Hora shows you the contents of a table or view as a grid, form or text and guides you automatically to every referenced table. You can enter data, and make changes or deletions. Hora makes everything easier with an integrated reference function, a line copying function and a memo field editor for VARCHAR2 columns and LOBs. In the latest versions we have made things even more convenient. You can sort the data by simply clicking on the column header. And filtering is also possible with a mouse click on the combo box in the column header. Even grouping of data is possible. Just drag the column for the grouping into the Group By box. Do you need to evaluate the grouped data (total, average, minimum, maximum, …)? No problem! One click in the Footer group and you can already see the average income per department. Hora offers this level of comfort, which you would only expect to find from a table calculation, not only for the data contents, but wherever the data can be presented in tabular form.
SQL and PL/SQL support
The SQL Workbench allows you to produce scripts and PL/SQL blocks and also to store these for execution later. Joint project work is supported by the possibility to store SQL Code in a network. An output window can be used to either display or store the result set, to output the explain plan, or as PL/SQL output window (DBMS_OUTPUT). The integrated SQL editor offers syntax highlighting, options for formatting, and also the option of compiling and implementing the source code during the development. In the current version there is also code folding. In an outline window you can see the structure of the source code and can move with a mouse click to a procedure in a PL/SQL package. Hora supports the development, translation and testing of packages, procedures, functions and triggers directly in the database. Syntax errors are marked in the editor and objects can be recompiled after the error has been corrected. The modified source code can be stored.
Hora shows the current state of Redo log files, SGA, initialisation parameters, and cache, and also how full tablespaces are. Horaâ??trade;s Performance Monitor shows you all the key system parameters as dynamic graphs. This gives you an overview of the current performance of the database. You can use Hora to set up and delete data files, to start and stop jobs as well as to send data to pipes and to receive data from pipes. You can set up or delete users and display privileges and rolls with their contents. With Hora’s Session-Manager you can identify locks, display the active SQL instructions and end a session. Hora can display, generate, alter and delete almost all necessary database objects (tables, views, procedures, sequences, triggers, etc.). You can rename and delete columns and move tables from one tablespace to another.
From Hora, you have direct access to three additional tools:
The Reverse DDL Engineer generates an SQL script with which you can copy all or part of a schema to another database.
The HTML Documentation Generator generates an HTML-documentation from an existing database with just one click. The result is a professional report about the data model, complete with hypertext target position between
the referenced tables.
The SQL Editor can be started as an independent tool.
Summary: Hora, Oracle, editor, source code, Editor, Java, Footer group, Engineer
Concepts: SQL, Source code, Programming language, PostgreSQL, Oracle Database, PL/SQL, Data Manipulation Language, Table
/technology and computing/software/databases
/home and garden/home furnishings/sofas and chairs
/technology and computing/programming languages/visual basic
Tags: Hora, source code, data, SQL query builder, integrated SQL editor, Convenient data navigation, database, PL/SQL output window, data contents, database sessions, active SQL instructions, database objects, Data Manipulation Language, extremely powerful program, consistent user guidance, Footer group, memo field editor, necessary database objects, integrated reference function, mouse click, line copying function, Joint project work, column header, HTML Documentation Generator, Reverse DDL Engineer, SQL commands, SQL Code, hypertext target position, table data, SQL Workbench, PL/SQL support, SQL script, Database parameters, PL/SQL package, PL/SQL blocks, data model, Oracle Database, data files, Database administration, pre-defined reports, daily work, Oracle documentation, Oracle databases, Oracle tools, delete users, referenced tables, Visual SourceSafe, Java methods, code folding