SQL update/insert statement.

I have a table that I want to either update the counter on or else insert a new record if it doesn't exist.

In PL/SQL I can do a count(id) on the table and update it if > 0 or insert if not there ( equals 0 )

Is there a more efficient way of doing this in an SQL Statement?

Thanks!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 10:42:31 CST