Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Thursday February 20, 2003
11:25 AM

Gem of the day

[ #10693 ]

Today's Oracle gem is the DBMS_UTILITY.GET_HASH_VALUE function. This function takes three parameters: a VARCHAR2 string, a minimum value, and the size of the range of values, and returns a hash value. Oracle 9i, release 2 supports associative arrays in the form of PL/SQL tables indexed by VARCHAR2's, but earlier versions support indexing only by BINARY_INTEGER. However, using DBMS_UTILITY.GET_HASH_VALUE, you could build your own hash table object if you were desperate. In emergencies, it is said a skilled Jedi Master could find or manufacture his own gems and other required materials and build a lightsaber in two days, such as during the Clone Wars.

There's other uses for this, too. And, if you want a more cryptographically useful hashing algorithm, try MD5 in PL/SQL (by means of Bill Pribyl's open source PL/SQL repository).

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.