Ideal for Oracle database application development, our tools make you more productive at every stage of the software development cycle such as data modeling, database programming, software testing and maintenance. KeepTool helps you quickly get up to speed with legacy databases and perform any kind of data analysis and performance tuning.
If you are developing database applications, chances are very good that within days KeepTool will become the most useful tool in your development process. We will highlight a couple of tasks our tools may help to improve both productivity and quality of your work.
Hora allows you to interactively view, create and modify database objects such as tables, views, PL/SQL programming logic, etc. Easily manage permissions on database objects, create synonyms and view dependencies between objects. You can create DDL statements for existing database objects and compare changes.
Edit and compile your PL/SQL source code in a convenient editor window that supports syntax highlighting. View PL/SQL error messages and highlight error locations. Automatically create an anonymous PL/SQL block that acts as a call interface for testing. Capture dbms_output messages and debug your code step-by-step while viewing the current source code position and local variable values.
SELECT, INSERT, UPDATE and DELETE statements can be generated in several ways. Simply drag the icon of a table or view into the code window and choose from several context menu options. Or, right-click a table name selected in the code window and select a similar menu item to create DML statements. Similar operations are available for procedural objects to generate the correct syntax of a PL/SQL call.
For queries on joined tables, you can use the interactive query builder. It creates queries in either ANSII or Oracle native syntax.
The Data Content Browser is a very convenient tool for interactive data analysis. You can filter data using both SQL filter expressions and Query by Example (QBE) technologies. Visual data grouping and summation are available.
Move from master to detail table contents and vice versa by following foreign key constraints. Automatically lookup foreign key values from master tables. Organize your table views into work sets for reuse another day.
Create INSERT, UPDATE, and MERGE SCRIPTS to transfer data to another database.
Hora’s schema page gives you a first look at the health of the schema. It shows PL/SQL errors, disabled or not validated constraints, unusable indexes, disabled triggers, policies, tablespace utilization, and a cross-table view of object privileges granted to roles and users. Drill down to detailed views for more information.