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

Comments

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

Hi.

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. :)

Cheers

Tim...

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

Regards,
Sayan Malakshinov

Tim... said...

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

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired