Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dropping a auto-increment on a table

RamaniNJNov 3 2015 — edited Nov 3 2015

Hi:

I started using the auto-incrementor available in 12c. I personally think it's the greatest feature since the slice of bread. No longer to you have to create a sequence and use the trigger to get the next value. I can use trigger for much better things.

But here's the problem I have run into. I have created a table wrongly identifying a column as an auto-incrementor.

I tried altering the table and dropping the default but I get errors.

Thanks.

venki


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2015
Added on Nov 3 2015
6 comments
2,735 views