Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Entering generated unique value.

Re: Entering generated unique value.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 05 Feb 2001 14:31:47 GMT
Message-ID: <3a7eb940.2321771313@news.alt.net>

On Sun, 04 Feb 2001 19:09:23 -0800, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:

>Oracle provides a database object known as a SEQUENCE specifically to
>perform this function. It does it perfectly and faster than anything you
>could possibly write yourself. I strongly urge you to use the
>functionality already built into the database.
>
>Daniel A. Morgan
>

Please note, that a sequential number is not useful here, I already have an a sequence generating sequential Ids for the row. This generated id, is of fixed length, and is used specifically for obfuscation.

Brian Received on Mon Feb 05 2001 - 08:31:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US