Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to insert values?
Create tables then insert the parent row, the child row, then the next
parent row, ....
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Me" <me_at_privacy.net> wrote in message news:aavfcv8f4qb7kkg36rba6i26v2cdhoclvm_at_4ax.com...Received on Sun May 18 2003 - 16:44:12 CDT
> On Sun, 18 May 2003 13:23:38 -0700, Ana C. Dent wrote:
> :The "obvious"(?) solution is to.....
> :
> :DISABLE the primary & foreign keys.
> :Load the data into the tables.
> :ENABLE the primary & foreign keys.
>
> Yes, that is an obvious solution. I infact used an 'obvious solution'
> even when I had problems creating the tables because each one had a
> foreign key!
>
> But is there a 'more correct' or 'elegant' solution to
>
> 1) Creating the tables
> 2) Inserting the values (with foreign and primary keys enabled)
>
> Thanks.
> --
> Good night