I have created a table using Oracle 8 (on win98se) as follows :
create table sales_order
(sales_order_no varchar(6) primary key,
constraint sorderno check(sales_order_no like('O%')),
s_order_date date,
dely_type char(1) default 'F',
constraint deltype check(dely_type in('P','F')),
constraint delydate check(dely_date>s_order_date),
order_status varchar(10),
constraint orderstat check(order_status in('inprocess','fullfilled','backorder')))
;

Now I want to modify the last constraint to include one more option for 'cancelled' along with the options present i.e inprocess,fullfilled, backorder .I want to know the command line editing for it.
Please help.