oracle table default values,Alter Table Add column not null default value

user10390682 wrote:

I tried this, but didn't workSince you are specifying default values, it should work (regardless if table DWSODS01.DWT00301_ORD_DTL_OMS is empty or not):

SQL> select count(*) from emp1

2 /

COUNT(*)

----------

14

SQL> alter table emp1 add (

2 COMB_ORD_FLG NUMBER(5,0) default 0 not null,

3 COMB_ORD_NO NUMBER(12,0)

4 default 0 not null);

Table altered.

SQL> desc emp1

Name Null? Type

----------------------------------------- -------- ----------------------------

EMPNO NUMBER(4)

ENAME VARCHAR2(10)

JOB VARCHAR2(9)

MGR NUMBER(4)

HIREDATE DATE

SAL NUMBER(7,2)

COMM NUMBER(7,2)

DEPTNO NUMBER(2)

COMB_ORD_FLG NOT NULL NUMBER(5)

COMB_ORD_NO NOT NULL NUMBER(12)

SQL>What error are you getting?

SY.