|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.
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
Tim... said...Sayan: Thanks for that. I will check it out and amend the article when I've played with it. :)