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)


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

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!