Re: OCI: Does object already exist ?

From: Nicolas Issakides <nissakid_at_planete.net>
Date: 1998/02/15
Message-ID: <34e6c4b1.0@Kampot.pci>#1/1

Via indexes / contraint.

just insure that your tables have the appropriate index so that the record can be unique and directly identified.

When you try to enter it again, Oracle will return an error

In article <01bd38c9$f9489f30$847253ce_at_deepwater>, "Gerry West" <gwest_at_skyconnect.com> wrote:
>Hi All,
>
>Can someone tell me if there is an easy way to find
>out if something already exists in the database ?
>
>I want to find out so I know whether to insert it or update it.
>
>In Pro*C I did a select count(*).
>
>Now in OCI I'm doing a fetch and checking the cda.rpc
>
>Is there an easier way ?
>
>Thanks in advance,
>Gerry
>

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Sun Feb 15 1998 - 00:00:00 CST