Re: PL/SQL Question

From: <raman.yagna_at_db.com>
Date: Wed, 13 Sep 2000 09:59:30 +0800
Message-Id: <10617.116784@fatcity.com>

Hi,

        select 1 into x from dual
         where exists ( select * from table where primarykey = 1234 );

if x != 1
     insert

else

    update
end if;

Raman

• Message History ----------------------------------------

From: hdaiminger_at_vivonet.com on 13/09/2000 00:57 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: PL/SQL Question

Hi!

I do have a weird problem to solve. I wanna check if a specific record already exists in a table (select * from table where PrimaryKey = 1234). If it does, I wanna do an update on that record and if it doesn't, I wanna insert a record.

What would be the best (and least expensive) way to achieve this in a procedure?

Thanks,
Helmut

--
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Sep 12 2000 - 20:59:30 CDT