My Oracle Support Banner

RDBPROD: How to define an automatic column that maintains an update count of a record (Doc ID 734587.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium



Goal

Sometimes you need to count how many times a specific record is updated. This can be done using an update trigger or an automatic column.

This will be described in this document.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Using an update trigger:
 Using an automatic column:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.