Scenerio:

Table:    INQ

Fields:    rdsp ,rdcyl ,rdax ,rnsp ,rncyl ,rnax  Number(9,2), na varchar2(50) list item

Values:  -3.00,+1.00, 65, -2.00, +0.75, 115,                              Near, Near-ADD, ‘ ‘

I have list value which has two values like(NEAR,NEAR-ADD). I have a table which have six columns above . when I create new record it will add NEAR-ADD in fields values in (rdsp)column and (rnsp)column. When I select value NEAR it will perform +/- function on (rdsp,rnsp) columns but when I select value NEAR-ADD it will show the previous value which I put at the time of insert. No change in it.

if i not select any value from list item. the next_item will performed.

Please advised.