Re: Entering generated unique value.

From a functional stand point I do not understand what you are trying to do. But if you want a unique value for an index sequences are the answer. If you want unique values that are not numeric ... either apply TO_CHAR() or BITAND.

Dan Morgan

Brian Tkatch wrote:

> 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 - 23:57:13 CST