alter table modify column to a default value
Hi Guys,
I want to alter a column in a table to default a value to 1.
I used the following syntax:
ALTER TABLE schema.table_name MODIFY(column5 DEFAULT 1);
But when I do the desc schema.table_name on sqlplus...
I dont see that default value:
That is :
SQL> desc schema.table_name
Name Null? Type
----------------------------------------- -------- ----------------------------
column1 NOT NULL CHAR(5)
column2 VARCHAR2(15)
column3 VARCHAR2(25)
column4 NUMBER(6)
column5 NUMBER(1)
column6 NUMBER(13)
How do I see if the values where defaulted on that column?
Or it will be handled during the inserts?
Please Help !!!!!!!!!!!
Thanks