8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Identity Columns in Oracle Database 12c Release 1 (12.1)

Identity Columns in Oracle Database 12c Release 1 (12.1) - Replace trigger-based population of numeric ID columns with the new identity functionality in Oracle Database 12c Release 1.

Danicela said...

GENERATED ALWAYS AS IDENTITY does not seem to work, I get a 'missing right parenthesis' error.

Tim... said...


Are you sure you are on a 12c database? This is a 12c new feature. I only get that problem if I try to run the code on 11g. :)



Sayan Malakshinov said...

A couple additions, which i already wrote: http://orasql.org/2013/07/13/oracle-12c-behavior-tests-of-the-inline-functions-identities-and-defaults/
1. we can see all sequences for identities in the sys.idnseq$
2. we can see sequence usages in the plans now

Sayan Malakshinov

Tim... said...

Sayan: Thanks for that. I will check it out and amend the article when I've played with it. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!