All geek questions in one place

Sequences vs. Identity Columns in Oracle

Is it better to use sequences in oracle and automatically grow the column using Before insert trigger or use identifier columns since it is available in Oracle 12 c?

+4
source share
1 answer

In any case, you will use sequences. The identity columns in 12c use the same mechanism behind the scenes.

Advantage - db manages these objects, not you.

enter image description here

This feature was introduced to help migrate systems from places like SQL Server and Sybase ASE, where they were popular. It is much easier to migrate as is than to create a sequence / trigger pair to keep moving forward.

Oracle. IDENTITY , .

+6

Source: https://habr.com/ru/post/1694782/

More articles:


All Articles