Wednesday, July 25, 2012

Oracle Database 12c - New Feature: Identity Columns


Well, Oracle Database 12c is not yet available but new features seems to be popping out in MOS. While troubleshooting Oracle Enterprise Manager Cloud Control 12c startup issues I came across Oracle Database 12c new feature called “Identity Columns”.

An Identity Columns is auto-incremented at the time of insertion just like in SQL Server. Going forward, I think you will not use Oracle Sequence anymore to generate unique values instead use Identity Columns.

For more information on this read:

HOW TO CREATE A TABLE WITH APRIMARY KEY USING AN IDENTITY CLAUSE [ID 1472346.1]


Happy reading!!!
at

8 comments:

  1. Mahir M. Quluzade1:34 PM, July 25, 2012

    Really interesting, Where we shall use sequences after 12c?

    Thanks for share

    Mahir M. Quluzade
    www.mahir-quluzade.com

    ReplyDelete
  2. LewisC4:11 PM, July 25, 2012

    I'd much rather see sql booleans. I guess this will make it easier to convert from other databases since most have an identity column.

    ReplyDelete
  3. Laurent Schneider8:31 PM, July 25, 2012

    good catch! using sequence was really odd...

    ReplyDelete
  4. Marko Sutic9:37 PM, July 25, 2012

    Interesting. Nice new feature.
    Thanks for sharing!

    Regards,
    Marko

    ReplyDelete
  5. Andreas3:25 PM, July 26, 2012

    Same identity clause as DB2. Hopefully Oracle does the import and export options for identity columns better compared to DB2.
    Regards,
    Andreas

    ReplyDelete
  6. ronr.blogspot.com3:31 PM, July 30, 2012

    Can't read the article :-(
    Just hoping they don't forget about bi-directional replication issues...

    ReplyDelete
  7. Asif Momen3:40 PM, July 30, 2012

    @Ronald,

    Yea, the article goes missing from MOS. May be it was mistakenly put on by the Support Engineer. :)

    ReplyDelete
  8. JAW6:29 PM, November 19, 2012

    This is just Vendor conversion play!

    DB2 was the first of the big 3 to support IDENTITY and SEQUENCE at the same time back around V4, IIRC.

    SQL Server 2012 supports the SEQUENCE construct.

    Oracle 12c will now support both.

    It means that if get get PO'ed with one vendor its easlier to convert to the competitors.

    DB2 even has PL/SQL Syntax support for Oracle conversions.

    ReplyDelete