Supports Identity column for Oracle – PB Docs 2022

When a DataWindow object is created, the Identity column is
automatically set (read from the database). You can modify the
Identity column in the Specify Update Properties.

When inserting rows with an Identity column, the Identity
column is excluded from the INSERT statement. Its value is
generated based on the GENERATED BY DEFAULT.

After a new row is inserted, the value of the Identity
column in the row will show after the Update.

Note: The DataWindow
automatically gets the biggest value for the Identity column in
the newly-added row after the Update. Therefore if the Identity
column auto-increments by a negative number (which is supported by
Ora Oracle and ADO.NET, but not by ODBC), the value shown for the
newly-added row may be incorrect. You can execute a Retrieve on
the DataWindow to get the correct value.

It is now supported to directly add auto incremental columns
for Oracle tables in the IDE database painter: You can do it by
setting the data type of the columns to either NUMBER IDENTITY or
FLOAT IDENTITY. The clause would be: