Re: ideas to use ora hash

On 3/21/06, Glenn Santa Cruz <glenn.santacruz@xxxxxxxxx> wrote:
> Not sure how you'd apply this to tuning, or to reduce storage space,
> but we used it to provide a pseudo-random ordering of rows for a
> particular application.  The requirement was to provide a random list
> of entries from a table, but the list needed to be "page-able" (think
> of web site, displaying page 1 of 10, etc).  We couldn't just order by
> dbms_random.random, since that would effectively break pagination; and
> we had to keep these in order for the particular web session.
> Solution?  Concatenate the unique web session identifier with another
> unique column in the table and sort by the hashed value.  Worked quite
> well.
>
> Glenn
>
> On 3/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
> > Hi list
> > Does anyone has an interesting idea about how to use, specially for tuning,
> > ora_hash or DBMS_UTILITY.GET_HASH_VALUE, to get hash values.
> >
> > One is to encrypt, but I was asking about the possibility to use to
> > reduce storage space or to tune, does anyone can share some idea
> > and/or experience.
> >
> > Thank you :)
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>


--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l

Other related posts: