Want to bring the SHA-256 Hashing algorithm to Oracle 11g R2? Here is how to implement a hashing method that isn't natively supported by the database.

Download Oracle Database 11g Express Edition for free. Oracle Database 11g Express Edition is a free program that provides a browser-based interface to administer databases, create tables, views and other database objects, import, export and view table data, run queries and SQL scripts, and generate reports.

  1. Do you happen to now if imp oracle command is included in the oracle client tools 11g for MAC OS? Actually I have download the packages but I can't seem to find it and I am wondering if there is a.
  2. How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file. I now have the following files under /downloads/instantclient.
  3. Oracle 11g For Mac. Hello Guys, I wished to Exercise Oracle Database Administrator Tutorials on my Mac pc Operating-system (Host Operating-system) Therefore, went forward and do the Using: 1.) Recently Set up (.dmg) on My Macintosh OS Successfully, 2.) Also Down loaded the VM (Digital Device) Image of which can be Brought in into the 'Oracle.
Install oracle database on mac

Join the DZone community and get the full member experience.

Join For Free

As you know, Oracle offers some support for encryption and hashing in the database. Taking advantage of this underlying infrastructure offered by Oracle allows us to accelerate our business considerably.

With Oracle 11g R2, we can see that there are many ways to look at the structure provided to the user.


When we look at the list, we see that Oracle 11g R2 does not have every method. One of these methods is the SHA-256 Hashing algorithm. This support was provided with Oracle 12c, but if we do not have the option to upgrade the database, we can implement the SHA-256 method indirectly.

To implement this method, I will use the ability to create Java classes within the Oracle database. So in summary, I will do the data hashing with the help of a Java code that I write in the database. Later, I will wrap this java code with a PL/SQL function and use it as a normal SQL function.

Install Oracle Database On Mac

First, I create the Java class in the database that will implement the SHA-256 method:


We created our Java resource in the database. Now let's write a PL/SQL function that will wrap this resource:

Oracle


Install Oracle On Mac

We wrote the PL/SQL function. Now we can test it:


Oracle Sql Developer For Mac

Sql

Yes, with this example we have implemented a hashing method that is not supported by Oracle 11g R2.

Oracle Instant Client For Mac

Oracle

Oracle 11g For Mac Os

hashing,oracle database,plsql,encryption,database,tutorial

Oracle Database For Mac

Opinions expressed by DZone contributors are their own.