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!

removing the default value of a column

560055Aug 28 2007 — edited Aug 28 2007
Hi,
I need to remove the default value set for a column.
The column is varchar2(15) with default value as $$.
I just want to remove that default value.

i tried

alter table tab1 alter column cols1 drop default

This didn't worked.

Thanks in advance
Aji
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2007
Added on Aug 28 2007
2 comments
452 views