OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Default Value (11g database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Default Value [message #639589]

Fri, 10 July 2015 23:29

cool06prashant
Messages: 9
Registered: September 2014
Location: delhi

Junior Member

If A Table Having default value ex. test char(1) default 'Y';
But After Sometime i want to remove that default value for furture entries
and if we "desc table" then same column show as i.e test char(1) ;

Report message to a moderator

Re: Default Value [message #639590 is a reply to message #639589]

Fri, 10 July 2015 23:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

cool06prashant wrote on Fri, 10 July 2015 21:29

If A Table Having default value ex. test char(1) default 'Y';
But After Sometime i want to remove that default value for furture entries
and if we "desc table" then same column show as i.e test char(1) ;

so how can we assist?

Report message to a moderator