KeepTool Blog - Current

The article describes how to install ORDS on your database, and how to create and test ORDS Webservices with KeepTool Hora 16.

The second article about Oracle XML DB explains how you use KeepTool to create a XML based data export interface: - Creating PL/SQL types - Creating the XSD schema - Interface table for data export - Data export logic

The first article in our series about Oracle XML DB explains how you use KeepTool to create a XML based data import interface: - A sample use case - Creating PL/SQL types - Creating the XSD schema - Interface table for data import - Data import logic - Displaying the imported data

Today we show how to use Oracle SQL*Net encryption and checksumming when using the direct TCP/IP Connectivity: - Enabling Oracle SQL*Net encryption on the database server - Enabling Oracle SQL*Net encryption in the Oracle client - Using SQL*Net encryption with the direct TCP/IP Option - Monitoring Oracle SQL*Net encryption - Data Integrity Checksumming

We will show you how you can flag your personal subset of database objects by assigning an appropriate icon: - How to flag database objects - Keeping organized - Sample use case

This blog introduces new key features of KeepTool 15 such as: - MS Windows 11 and Oracle 21c database support - XML DB improvements - Flagging database objects - Data encryption with direct TCP/IP

Oracle schema dependencies is the topic of our newsletter: - Oracle schema dependencies explained - Oracle schema dependencies diagram - Drilling-down object dependencies

The memoptimized rowstore provides the capability of fast data lookup for tables that are mainly queried based on primary key columns. We show you how to use with KeepTool.

In this post we introduce two new features of KeepTool 14.2.0: - Escape Unicode characters in SQL - Filter expression editor

Today we show you how to display a list of most recently executed SQL commands and how retrieve a statement for re-execution. Furthermore, the blog introduces some new features of KeepTool 14.1.6.