Re: 'IF EXISTS' functionality in Oracle SQL

Steve Ball wrote:

> 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.

STORED procedure

    select * from a,b,c
    update blah_blah_blah
end
exception

    when no_data_found

        insert into blah_blah_blah
[...]

HTH Received on Mon Mar 13 2000 - 07:45:07 CST