Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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

Add your comments here.
(max 400 chars - plain text)