Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select all columns of a table in ora_hash function?

2897865Mar 9 2015 — edited Mar 10 2015

How can I select, in a ora_hash function, all the columns of my table to get a hash value? I have the following query:

select sum(ora_hash(column_1||'|'||column_2||'|'||column_3)) FROM my_table; 

This query gives me a number, it's 13913007220. Now I want to do the same query without having to specifie the names of each column. Something like:

  select sum(ora_hash(*)) FROM my_table; 

(this gives me an error like: 00936. 00000 - "missing expression")

How can I do this?

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2015
Added on Mar 9 2015
22 comments
9,183 views