'IF EXISTS' functionality in Oracle SQL

All,

I have some SQL written that worked on a Sybase or MS SQL Server db, but not Oracle:

if exists (select ...)
update my_table
set my_table.status = "65"
where
my_table.id = ...

Basically, I'd like to find out if something exists, and if it does (or doesn't!) contain the data, I'd like to update the table.

I don't think (I've looked) that there is the equivalent 'if exists' in Oracle, and I've looked at the decode statement, but I could not see that it would work for what I wanted.

What I'm looking to do is add a row to a table ONLY if some other select returns 0 rows.

Any help appreciated,

Thanks

Steve Received on Mon Mar 13 2000 - 06:32:09 CST