KeepTool Blog - Current

Custom INSERT Scripts with Sequences and Constants

01 Sep 2025

KeepTool (Hora) now offers more flexibility in generating INSERT scripts. You can set columns to use sequences like DEPARTMENTS_SEQ.NEXTVAL, the current timestamp, or any function/constant—instead of exporting existing data—making it easy to create fresh inserts for test setups or data initialization.

Stronger Security with AES-256 Password Encryption in KeepTool

05 Sep 2024

KeepTool now offers enhanced protection for saved database connection passwords through a robust AES‑256 encryption mechanism using a master password–protected KeyStore. All stored passwords are re‑encrypted securely, ensuring top-tier safety without compromising convenience.

Easily Migrate Legacy dbms_job Jobs to Oracle Scheduler with KeepTool

21 May 2024

KeepTool simplifies the transition from traditional dbms_job definitions to the more powerful Oracle Scheduler. With just a click, you can generate PL/SQL scripts to replace legacy jobs with scheduler-based ones—supporting bulk migration, optional cleanup of old jobs, and enabling access to the advanced features of Oracle Scheduler—all within KeepTool’s intuitive interface. keeptool.com

View All Your Related Data at Once with the Flat Detail Data Browser

22 Jan 2024

KeepTool introduces a powerful new way to explore sub-detail data: the Flat Detail Data Browser. Instead of clicking through layers of master/detail tabs, this modal dialog unfolds the entire foreign‑key hierarchy in one view—letting you see all related records in a single grid, edit the SQL, and leverage features like INSERT script generation or Excel export seamlessly. A game‑changing upgrade for productivity when dealing with nested data relationships.

Speed Up Large Data Inserts with Oracle Bulk Insert Scripts in KeepTool

07 Nov 2023

KeepTool now offers enhanced Insert script generation—producing INSERT ALL bulk insert statements that group multiple rows into one command for faster execution. You can also opt for direct path inserts, split large scripts into manageable files, add timestamp literals, and escape non‑ASCII data—making large-scale data migrations smoother and more efficient.

Creating ORDS (Oracle REST Data Services) with KeepTool

18 Sep 2023

KeepTool makes it easier than ever to configure and test Oracle’s ORDS—enabling you to expose your Oracle data as RESTful services with full CRUD (GET, POST, PUT, DELETE) support. Leverage its HTTP(S)-based endpoints for seamless JSON responses—all from within KeepTool’s intuitive interface.

Build XML Data Export Interfaces with Oracle XML DB and KeepTool

03 Mar 2023

In Part 2 of this series, you’ll learn how to construct a streamlined XML export interface using Oracle XML DB in tandem with KeepTool. The tutorial demonstrates building key PL/SQL types, registering export-ready XML schemas, and crafting procedures that generate hierarchical master-detail XML exports—stashed in an interface table—for seamless data-sharing workflows.

Build XML Data Imports with KeepTool and Oracle XML DB

23 Jan 2023

Dive into the first installment of a two‑part series where you'll learn how to leverage Oracle XML DB alongside KeepTool to build an efficient XML-based data import interface. This post walks you through defining PL/SQL types and registering XML schemas, culminating in a functional solution to import HR‑EMPLOYEES data—ready to be extended with custom logic for your own projects.

Secure Oracle Connections with SQL*Net Encryption & Checksums

20 Sep 2022

KeepTool now empowers you to configure and monitor Oracle’s native SQL*Net encryption and data integrity checksumming, even when connecting directly via TCP/IP. You can enforce encryption parameters (ACCEPTED, REQUIRED, etc.) without altering sqlnet.ora, and easily track both encryption and checksum status per session in the new Sessions → Network client tab—giving you full visibility and control over your network security.

Never Lose Sight of What Matters in Big Schemas

18 Feb 2022

KeepTool lets you flag your database objects—assign icons like colored bullets, stars, or warning signs directly within your object overview. Once flagged, items remain visually marked across all KeepTool components—from the query builder to ER diagrams—making it fast and easy to keep track of the tables, packages, or sequences you're focused on managing.