Special Columns

Oracle AI Database has hidden, invisible and system columns. Some databases may call them unused/virtual columns. These hidden columns would be included in the target table if the target database supports it, such as in the case of like-to-like data replication.In other cases, these columns are excluded from the target table, unless there is a use case for them to be created on the target.

Automatic increment or identity column is a special column with a default starting value. This value is automatically incremented for every new inserted record. This column is identified only in its base data type, integer.