You can translate the question and the replies:

Corresponding function Denodo to ORA_HASH in Oracle

Can you help me with corresponding function to ORA_HASH function in oracle. we're using Denodo 7.0
user
15-02-2022 07:21:18 -0500
code

1 Answer

Hi, I understand that you are looking for an equivalent function for "ORA_HASH", if that is the case, you can create a Custom Function to compute the hash value of the given expression. You can refer to the [Creating Custom Functions with Annotations](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_functions/creating_custom_functions_with_annotations#developing-custom-functions-that-can-be-delegated-to-a-database) section of the Virtual DataPort Developer Guide and [Custom Components](https://community.denodo.com/tutorials/browse/customcomponents/index) tutorial to create a custom function. Alternatively, if you intend to retrieve the hash value of the expression using the MD5 algorithm, you could use the [HASH](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/other_functions#hash) function supported by Denodo. Hope this helps!
Denodo Team
16-02-2022 07:41:11 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here