Re: has partitioning on a number

tq wrote:
> Does anybody know how to predict which hash partition a value will fall
> into if the hash-partitioned column is a number? I know
> dbms_utility.get_hash_value works for strings, but I'm trying to find a
> way with numbers.
>
> Thanks.

Why?

Anyway ...

SELECT ORA_HASH(<value>)
FROM dual;

All documented at www.psoug.org
click on Morgan's Library
click on ORA_HASH

Of course you didn't include a version number so your mileage may vary.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)