hi all,
we have a requirement to create a table with column ID which will be an IDENTITY column like:
id NUMBER GENERATED ALWAYS as IDENTITY
and we will import data from a MYSQL table through INSERT statements.
want to ask how we can manage this column data, oracle not allowed to include this column to insert data, how we can have the existing data and oracle should start after its last row? we knew it that we can use previous method to create a sequence and on insert trigger, but what if we want to use this feature.
regards