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!

Change the default value of certain column in a table in oracle 11g

fadiwilliamAug 18 2013 — edited Aug 18 2013

I have a table called cust_file, his table consists of a lot of columns (one of these columns called cus_tax) and have a lot of data,

I use oracle 11g, I want to change the default value of the column cus_tax to be equal 1,

I wrote

ALTER TABLE cust_file MODIFY(cus_tax DEFAULT 1);


table altered


but after I inserted new data to test the operation, I found that the new record has a value = null for the column cus_tax


thenĀ  I tested using the following query


select data_default from all_tab_columns where table_name='CUST_FILE' and column_name='CUS_TAX';

no rows selected


so please help me to Change the default value of the column cus_tax.



Thanks for any help.



This post has been answered by Hemant K Chitale on Aug 18 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2013
Added on Aug 18 2013
3 comments
881 views