Hashing a bank account details in file only


I like to send a text file containing employee information.
Only one of the fields which is 'bank account number' needs to be displayed in hash format.

I am using Oracle database and this data is not normal format (123456656707800) in the database and in the file currently.

how can this be done? , given that information also need to be extracted after I send it to the client on their side.

Thanks in advance
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
I'm not sure I completely understand what you are asking.

I don't think you want a hash.  Hashing is a one-way algorithm.  It could not be undone on the other side.  If it needs to be undone on the other side, you need to use encryption.

I would do that using DBMS_CRYPTO.  Documentation here -> http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_crypto.htm#ARPLS664

There are many examples in the documentation.  They also show how to covert the raw variable that comes back into something suitable for character storage (there are a few different recommendations in the doc).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
awking00Information Technology SpecialistCommented:
What happens with the file when it reaches the client? Are they loading it to an Oracle database table?
shmzAuthor Commented:
It will be extracted into an application called TimeSoft.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

awking00Information Technology SpecialistCommented:
It's still not clear to me what you need. Are you saying that, for example, you have a bank account number that shows 1234 when you select it from the Oracle database but, you encrypt it some fashion when you extract it to a text file so it shows up as $C@A and you need some means of converting it back to 1234 when extracted to the TimeSoft application?
shmzAuthor Commented:
yes, I need encryption on my side and would be good to provide them with info how to encrypt it on their side if you are familiar with Timesoft?
slightwv (䄆 Netminder) Commented:
johnsone provided the best method of encrypting the data on Oracle's side.

You will probably need to work directly with Timesoft to see what methods they have to decrypt the data on import.  I tried to locate some online documentation on their product but was unable to locate anything.

Once you know what their product supports, we can see what options Oracle has to be compatible.
shmzAuthor Commented:
Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.