Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Entering generated unique value.
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