insert with update......

[raf]

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

[jmodic]

MERGE. Check SQL Manuals for syntax.

[raf]

my oracle version is 8.1.7.0

Is it possible with this version??


Thanks

[jmodic]

No, in this case you need 2 sql statements (update + insert).