Decyrpt using select atatement
Posted by: Ferdie Palero
Date: April 06, 2017 09:43PM

Hi,

Anyone can help on how decrypt the data using select statement;

Input row:

encrypt_column
YjBhNjY5MzE3MWQ4ZDJmOR89/ChuhaRG0gOVBlfHmPmJ3SbZfsKJhCOOPrs98ui0
YjBhNjY5MzE3MWQ4ZDJmObCJqm2JTsFxDnWytJqnFU7asBXQCIUY5cYlrdSMcii7
YjBhNjY5MzE3MWQ4ZDJmOV210xNkpkW5iwWq7ehrG5e4VVBsBkiWrmio0TyKIZna


Output:

encrypt_column
test@ethical.com
applied@ethics.com
provider@lead.com

I've notice that most of the rows in my table having all "YjBhNjY5MzE3MWQ4ZDJmO"

Thanks in advance.

Regards,
Fspalero

Options: ReplyQuote


Subject
Written By
Posted
Decyrpt using select atatement
April 06, 2017 09:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.