Oracle 7.3 - Oracle 23c 20+ years of experience Version (Released: )

KeepTool Blog - Current

ORDS Oracle REST Data Services

18 Sep 2023

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

Oracle XML DB (Part 2) – Creating a data export interface

03 Mar 2023

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

Oracle XML DB (Part 1) – Creating a data import interface

23 Jan 2023

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

Using Oracle SQL*Net Encryption and Data Integrity Checksumming

20 Sep 2022

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

Flag your database objects

18 Feb 2022

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
Overview KeepTool Hora - Handy tools for Oracle datases

KeepTool 15 new features and improvements

06 Dec 2021

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 screenshot

Oracle schema dependencies

19 Apr 2021

Oracle schema dependencies is the topic of our newsletter: - Oracle schema dependencies explained - Oracle schema dependencies diagram - Drilling-down object dependencies
Backup SPFile to PFile dialog

Memoptimized Rowstore – Fast Oracle data access

23 Feb 2021

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.
Escape Unicode characters in SQL script

Escape Unicode characters in SQL and Filter expression editor

07 Dec 2020

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

SQL execution history – retrieve and re-execute

31 Aug 2020

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.