removing the default value of a column
560055Aug 28 2007 — edited Aug 28 2007Hi,
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