Re: Inserting Multiple Rows repeats the ID

From: gazzag <gareth_at_jamms.org>
Date: Thu, 14 Jun 2007 07:13:36 -0700
Message-ID: <1181830416.280011.139590@o11g2000prd.googlegroups.com>

On 14 Jun, 15:11, gazzag <gar..._at_jamms.org> wrote: [correction]

> Then your INSERT statement should end up looking something like the
> following:
>
> INSERT INTO HAND
> (CARDID,
> SUITID,
> RANKID)
> SELECT (HAND_SEQ.NEXTVAL, <------- this causes the value of
> DECK.SUITID,
> DECK.CARDID,
> FROM DECK
> WHERE ....;
>
> HTH
>
> -g

In my previous post the line "CARDID to be the next value in the sequence" should not be there. As above.

HTH -g Received on Thu Jun 14 2007 - 09:13:36 CDT