alter table NUM_GEN_SETUP_DTL_T add COLUMN_TYPE varchar2(1); alter table NUM_GEN_SETUP_DTL_T add COLUMN_EXPRESSION varchar2(100); update NUM_GEN_SETUP_DTL_T set COLUMN_TYPE='D';