KeepTool Blog - Current

KeepTool enhances how you work with Excel and Oracle. Export grouped and aggregated data from Hora directly into Excel — complete with formulas and structure — or import Excel sheets into Oracle tables in seconds. KeepTool even creates new tables automatically when needed, making your Excel-based data management faster, smoother, and smarter.

KeepTool makes browsing Oracle master-detail data effortless. Linked parent and child tables update instantly as you move through records, keeping both views perfectly synchronized. You can edit, insert, or analyze data across related tables without writing SQL — all from one intuitive interface. Ideal for Oracle developers and DBAs who want a clear, reliable, and productive way to explore relational data.

KeepTool makes exporting grouped Oracle data to Excel easier than ever. Group, summarize, and visualize your data in Hora, then export the results — complete with hierarchy, totals, and formatting. Your Excel output perfectly mirrors the Oracle view, allowing you to create professional, presentation-ready reports in seconds. Ideal for developers, DBAs, and analysts who value clarity and efficiency.

KeepTool introduces merged column grouping for smarter Oracle data analysis. You can now combine related columns, such as City and ZIP Code, into one logical group instead of multiple hierarchy levels. This makes your data view cleaner, faster, and easier to understand. Perfect for developers and DBAs who want to explore relational data more clearly and efficiently.

KeepTool introduces new features across Hora, ER Diagrammer, Reverse DB Engineer, and DB Compare to make Oracle database work even smoother. From smarter data browsing and grouped exports in Hora to clearer ER diagrams and faster schema comparisons, every improvement helps Oracle professionals save time and boost accuracy. Experience seamless integration, modern design, and performance enhancements — all in one unified toolset.

Back up your Oracle database structure automatically with KeepTool’s Reverse DB Engineer. Generate and schedule DDL script exports to ensure your schema is always protected. With simple batch automation and timestamped scripts, you can easily recreate or restore database structures anytime. Ideal for developers, DBAs, and teams that need reliable schema versioning and fast disaster recovery.

Migrating to a multibyte character set can cause unexpected issues with column sizes. KeepTool Hora’s Character Set Conversion Analysis helps you identify and fix affected columns before migration. The guided dialog shows current settings, highlights risky columns, and even generates SQL for further checks. This way, you can migrate to AL32UTF8 or any Unicode character set safely and without surprises.

KeepTool’s Hora now lets you execute an Oracle initialization script automatically after login. Define your script in the connect dialog and ensure that NLS parameters, language, and session variables are always set correctly — even when using direct TCP/IP connections. This feature simplifies configuration, ensures consistency across environments, and gives you full control over your Oracle session setup.

KeepTool adds more flexibility and convenience to your daily Oracle work. You can now borrow network licenses for offline use, save query parameters in the SQL Scratchpad, and enjoy consistent SQL generation across all modules. The improved PL/SQL editor also makes error detection faster and clearer. Together, these enhancements make KeepTool smarter, more intuitive, and ideal for developers and DBAs alike.

Missing indexes on foreign keys can cause table locks and slow performance during deletes or updates. KeepTool Hora helps you detect and fix these problems effortlessly. With its Constraints tab and “Create index on FK columns” feature, you can identify unindexed relationships and create supporting indexes directly—without writing SQL. Improve data integrity and concurrency in your Oracle database with KeepTool Hora’s intuitive interface and built-in optimization tools.