1-- ALTER TABLE <table> ADD <column> <type> <constraint>;
2ALTER TABLE members ADD age NUMBER;
3ALTER TABLE members ADD birth_date DATE NOT NULL;
4ALTER TABLE members ADD registering DATE DEFAULT sysdate;
5ALTER TABLE members ADD member_id NUMBER UNIQUE;
1alter table DWSODS01.DWT00301_ORD_DTL_OMS add (
2COMB_ORD_FLG NUMBER(5,0) default 0 not nulll);
3
4alter table DWSODS01.DWT00301_ORD_DTL_OMS add (
5COMB_ORD_NO NUMBER(12,0) default 0 not null);