get_hash_value oracle,get_hash_value

depending on your version of the database, you might want to look into using ORA_ROWSCN instead to detect changes in an optimistic locking scenario

SQL> select empno, ora_rowscn

2 from emp

3 /

EMPNO ORA_ROWSCN

---------- ----------

7369 5023481750

7499 5023481750

7521 5023481750

7566 5023481750

7654 5023481750

7698 5023481750

7782 5023481750

7788 5023481750

7839 5023481750

7844 5023481750

7876 5023481750

7900 5023481750

7902 5023481750

7934 5023481750

14 rows selected.

SQL>

SQL>

SQL>

SQL> update emp

2 set sal = sal + 100

3 /

14 rows updated.

SQL> commit;

Commit complete.

SQL> select empno, ora_rowscn

2 from emp

3 /

EMPNO ORA_ROWSCN

---------- ----------

7369 5023481764

7499 5023481764

7521 5023481764

7566 5023481764

7654 5023481764

7698 5023481764

7782 5023481764

7788 5023481764

7839 5023481764

7844 5023481764

7876 5023481764

7900 5023481764

7902 5023481764

7934 5023481764

14 rows selected.

SQL>