Re: Help with SQL constraint

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 17 Feb 2007 09:48:57 -0800
Message-ID: <1171734537.289337@bubbleator.drizzle.com>

dean wrote:
>
> The trace files are no longer available, and as I said I had them
> looked at already. But what I would find advantageous is a better
> technique for updating such joins as discussed, as there are several
> tables of similar construct that prevent an updatable join.

If you have the tables and the DDL we should be looking at to help you. And if you have the DML you've be running. What stops you from rerunning it with explain plan?

You are absolutely tenacious with respect to updating a join "as discussed" but is one of many possible solutions. You have yet to state an actual business problem.

By way of explanation this is how you might present a business problem.

We have one table with patient data where the primary key is PID and it has a status column that we need to update based upon a second table with patient data that contains their discharge date.

Absent such an explanation everyone is just floundering around wasting perfectly good electrons.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Feb 17 2007 - 11:48:57 CST