Hi everyone,
DB Version 19c
We receive information through an ORDS REST API into our database. We keep track on every request done by the users. We can not keep information on the user in our database, but we do need to be able to count the number of unique users visited our website. From the REST API request we take some values like firstname, lastname and company. We hash this information and only keep this hash in our database. Then we count the number of unique hashes.
We use the following method to hash our values:
sys.dbms_crypto.hash(utl_raw.cast_to_raw(p_text) , dbms_crypto.HASH_SH512);
Is this a good way of performing our unique count operation?
Is this generated hash guaranteed the same for the same p_text values? All of the time over time?
Thx for your insight and ideas.
Filip