Re: Multitable Insert Problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 22 Sep 2006 21:06:58 -0700
Message-ID: <1158984416.353485@bubbleator.drizzle.com>

Dereck L. Dietz wrote:

>>> The Insert:
>>>
>>> INSERT ALL
>>>
>>> INTO hmp_well_visits VALUES ( person_id )
>>>
>>>
>>> INTO hmp_well_visits VALUES ( person_id )
>>>
>>>
>>> SELECT DISTINCT a.person_id AS person_id,

> Thanks but I'm still totally baffled as to what is incorrect in my INSERT > ALL statement.

Do you see a difference between the above two INTO clauses? My guess is that Oracle's doesn't either.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Fri Sep 22 2006 - 23:06:58 CDT