valigula wrote:
>> Sounds like you might be able to achieve this with a multitable
>> insert, using "INSERT FIRST" and multiple WHEN clauses, driven off an
>> outer join of the source and target tables.
>
> Thanks ...
> How i can capture the exception raise, when the Fk is broken???
SELECT owner, constraint_name
FROM dba_constraints
WHERE constraint_type = 'R'
AND invalid IS NOT NULL;
--
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 Mon Apr 16 2007 - 10:22:06 CDT
