Re: Procedure Question

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 21 Aug 2002 17:27:30 GMT
Message-ID: <3D63CD74.FA1BA48D@exesolutions.com>

Amol wrote:

> 1) In my procedure i have input parameters that are from 2 tables and
> i want to insert/update that record in those tables acorrding to the
> record absent/present, whats the best way of doing it.
> the two tables are linked using 1 to many relationship.
> is 2 updates/inserts the best way to do that?
> If someone has a similar example can anyone attach that to this
> message.
>
> thanx
>
> sid

You have provided insufficient information from which to provide any meaningful help.

My suggestion would be to try what you are considering and examine it for performance using EXPLAIN PLAN and DBMS_PROFILER.

Daniel Morgan Received on Wed Aug 21 2002 - 12:27:30 CDT