KeepTool Blog - 2023

With KeepTool 16, creating INSERT scripts for large Oracle datasets becomes faster and easier than ever. New features like Bulk Inserts, Direct Path Inserts, and automatic script splitting dramatically improve performance and usability when handling high-volume data operations. Perfect for developers and DBAs who work daily with large Oracle tables.

With KeepTool 16, you can easily create and manage Oracle REST Data Services (ORDS) directly from Hora’s graphical interface. Enable schemas, define modules, templates, and handlers, and instantly publish REST endpoints returning JSON data — all without manual PL/SQL coding. Use parameters like ?id=123 or ?sal=10000 to filter results dynamically and integrate your Oracle data into web or mobile applications with just a few clicks.

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.

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.