The ORA driver supports the Identity columns for the Oracle database:
-
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.
-
You can directly add auto incremental columns for Oracle tables in the IDE database painter, by setting the data type of the columns to either NUMBER IDENTITY or FLOAT IDENTITY. The clause would be:
GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 START WITH 1
