Re: HELP: How to generate sequential Primary Keys on a maste
From: Philip Chee <philip_at_aleytys.pc.my>
Date: Sun, 07 Apr 2002 21:33:36 GMT
Message-ID: <1018215216.6011snx_at_aleytys.pc.my>
Date: Sun, 07 Apr 2002 21:33:36 GMT
Message-ID: <1018215216.6011snx_at_aleytys.pc.my>
In article <a8q58d077a_at_drn.newsguy.com> tkyte_at_oracle.com writes:
>In article <1018179580.6010snx_at_aleytys.pc.my>, philip@aleytys.pc.my says...
>they are doing it exactly the way I describe!
>I said:
>Heck, just issue "update invoice_table set invoice_number = rownum" when they
>walk in the door if you like. (thats the other sequential table you refer to)
>Using something else as the primary key of course (the invoice_id column is for
>the auditor who doesn't have a clue about computer systems, the primary key is
>for us). (thats the SEQUENCE)
Argh. <Re-reads thread from the begining>. Note to self: Don't post to usenet at 3 am local time!
Philip
---=====================================================================---Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932 Guard us from the she-wolf and the wolf, and guard us from the thief,
oh Night, and so be good for us to pass.
-- þ 20415.09 þ Hello, I am part number ³ºÞº³º³Û³ºÝ³ºÝ³³Received on Sun Apr 07 2002 - 23:33:36 CEST