Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: function to create unique key for rows?
Look into using a SEQUENCE. This will give you what you're after.
On Wed, 20 Oct 1999 23:21:42 GMT, Shmooth <shmooth_at_yahoo.com> wrote:
>I have a large table (@1M rows) with several columns of VARCHAR2 data
>that I would like to be able to create unique indexable keys for to
>speed look-ups.
>
>For instance, now I do this:
>Select myData From myTable Where col1=this and col2=that and col3=other
>
>and I'd like to be able to say this:
>Select myData From myTable Where
>new_indexed_column={some_value_i've_created}
>
>Does Oracle have a 'Hash' function of some type I can use to give each
>of these rows a unique indexable value?
>
>Thanks.
>
Received on Thu Oct 21 1999 - 09:30:12 CDT