Home » SQL & PL/SQL » SQL & PL/SQL » Compare 2 encrypted values (Oralce 12c - Release 12.1.0.2.0)
Compare 2 encrypted values [message #642432] Thu, 10 September 2015 10:59 Go to next message
raskotha
Messages: 5
Registered: February 2007
Location: Pittsburgh
Junior Member
Is it possible to compare 2 encrypted values? If yes, is there any oracle functions are there? or we can compare directly .. For example
col1 and col2 are having encrypted values - can i compare like col1 != col2?
Re: Compare 2 encrypted values [message #642433 is a reply to message #642432] Thu, 10 September 2015 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Is it possible to compare 2 encrypted values?


It depends:
1/ What do you mean by "compare"
2/ The encryption algorithm

If you mean equality and encryption depends only on the encrypted data, then yes.
Otherwise, no.

Quote:
can i compare like col1 != col2?


With the assumptions above, yes.

Re: Compare 2 encrypted values [message #642434 is a reply to message #642433] Thu, 10 September 2015 11:15 Go to previous messageGo to next message
raskotha
Messages: 5
Registered: February 2007
Location: Pittsburgh
Junior Member
Yes, with the same algorithm.

Thanks.

[Updated on: Thu, 10 September 2015 11:15]

Report message to a moderator

Re: Compare 2 encrypted values [message #642438 is a reply to message #642434] Thu, 10 September 2015 14:10 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Not just the same algorithm, but algorithm must not use other thing that the data itself and a fixed key to encrypt.
If the encryption of the same data does not lead to the same result each time than you can do nothing.

Previous Topic: hierarchial query
Next Topic: Search Oracle table and only list data depending on rows
Goto Forum:
  


Current Time: Wed Apr 24 09:21:44 CDT 2024