delete from CLOSING_PRICE where trxn_date='29-JUL-2005' 
/
alter table posmst add n_bot_qty_with_ex number(13)
/
alter table posmst add n_sell_qty_with_ex number(13)
/
alter table posmst add asg_qty number(13)
/
alter table posmst modify ref_id varchar2(15) NOT NULL
/
commit
/