0

i wanted to create a table with the property that auto increment the primary key id column value but could not. how do i do that in oracle sql.how to use the identity column value.

Vaibhav Mule
  • 5,016
  • 4
  • 35
  • 52
user1957167
  • 9
  • 4
  • i am using sql developer to work with – user1957167 Apr 16 '15 at 05:30
  • 3
    http://stackoverflow.com/a/11296469/599528 – Jacob Apr 16 '15 at 05:31
  • For **12c**, read http://lalitkumarb.wordpress.com/2015/01/20/identity-column-autoincrement-functionality-in-oracle-12c/ and for **prior 12c** releases, read http://lalitkumarb.wordpress.com/2015/01/20/auto-increment-primary-key-in-pre-12c-releases-identity-functionality/ – Lalit Kumar B Apr 16 '15 at 06:04

0 Answers0