Hi,
I've this table:
desc TAB1
DESCRIPTION VARCHAR2(20);
QUANTITY NUMBER;
DESCRIPTION........QUANTITY
APPLE............. 10
COFFEE............ 7
I'd like to insert into TAB1 a new record, but if the value of description exist, It update quantity without
insert a new record.
Is it possible do it with just one statement sql without any control structure??
thanks
Raf