Skip to Main Content

Oracle Database Discussions

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!

how to alter table and make one of it column column having default sequence value

Athish A SMay 5 2014 — edited Jan 8 2015

Hello Friend, I am seeking some help reg  altering table and make one of it column column having default sequence value in ORACLE 11g

ALTER TABLE  Persons MODIFY City DEFAULT my_sequence.NEXTVAL;

Its not working in oracle 11g ..

Please help me out

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2014
Added on May 5 2014
2 comments
4,097 views