Skip to Main Content
  • Questions
  • One way Encryption where no one can decrypt

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, GK.

Asked: November 08, 2019 - 9:36 am UTC

Last updated: November 12, 2019 - 11:06 pm UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi Tom,

Kindly suggest some one way encryption for the data in table,where no one can decrypt it?

Read few articles about this and not satisfied.

Kindly help.

and Connor said...

Sorry, I'm not following.

There is no such thing as "one way encryption". The definition of "encryption" is such that you *can* decrypt.

You might be referring to hashing? ie, the same input always maps to the same (garbled) output, and is non-reversible?

If that is the case, then check out either of:

dbms_obfuscation_toolkit
dbms_crypto

which contain routines to do hashes such as MD5, SHA-1, SHA-2 (SHA-256, SHA-384, SHA-512), MD4

There are examples of both on the AskTOM site just by searching

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

one way encryption

Laurent Schneider, November 11, 2019 - 1:15 pm UTC

I would recommend reading https://www.crypto101.io/Crypto101.pdf

If I have an input 123 and I encrypt this to ABC, no one can decrypt but me because I know how (I have the algorithm in my head). On the other hand if you have 123 and you produce hXz and noone can decrypt it, it is pretty useless.

Usually in encryption you have a key and an algorithm.

For instance, in its simplest form , XOR

I have value 5 and key 9
0x0101 (5)
XOR
0x1001 (9)
=
0x1101 (13)
5 XOR 9 = 13

and noone, without the key, can decrypt it

but with the key 13 XOR 9 = 5
0x1101 (13)
XOR
0x1001 (9)
=
0x0101 (5)

you should well protect your key (e.g. in a wallet), so nobody can access it.

While the algorythm evolves in the last 15 years, I still recommend Arup example : https://blogs.oracle.com/oraclemagazine/encrypt-your-data-assets

Cheers
Laurent


Connor McDonald
November 12, 2019 - 11:06 pm UTC

nice input

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library