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!!!

Oracle Certified Master (OCM)

Today I received a congratulations email from “Oracle Certification Program” for successfully completing Oracle 10g OCM. Being an OCM is really an accomplishment in a DBA’s career. OCM is the most advanced database credential for an Oracle professional.

I still have to wait for another 2-3 weeks to receive OCM-Kit and to get my profile updated under “Oracle Certified Master Profiles”.