Home » SQL & PL/SQL » SQL & PL/SQL » Encryption (merged)
Encryption (merged) [message #301635] Thu, 21 February 2008 03:42 Go to next message
Jayu
Messages: 14
Registered: August 2007
Location: India
Junior Member
Hi,

I need to replace the already encrypted data with some * or # symbol..Is this possible using Oracle Pl/SQL??

Basically i have one column in table where i store this encrypted data..Now the encrypted data is stored in form of s!$&6 but i need it in the below given form

*******.This should be stored in Table

Thanks in Advance.

Regards
Jayateerth
Re: Encryption [message #301638 is a reply to message #301635] Thu, 21 February 2008 03:49 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
And exactly how would you decrypt ****** back to HelloWorld?
Re: Encryption [message #301640 is a reply to message #301635] Thu, 21 February 2008 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you don't want the value, why not just :
select '**********' encrypted_column from mytable;


Regards
Michel
Re: Encryption [message #301672 is a reply to message #301640] Thu, 21 February 2008 05:38 Go to previous messageGo to next message
Jayu
Messages: 14
Registered: August 2007
Location: India
Junior Member
hi Michel,
Thanks for the reply.But what i want is two levels of encryption/decryption.I get a value from front end and it is stored in database in encrypted form.Again i want this encrypted data to be encrypted(i.e two levels of encryption) and to be stored in the database as '*'.

I am using Oracle 10g R2 database


Thanks in advance

Regards
Jayateerth

Re: Encryption [message #301678 is a reply to message #301672] Thu, 21 February 2008 05:53 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Again, how would you decrypt ****?

Suppose password for user 1 is HelloWorld. This encrypts to >sds8t5s. Now you encrypt further to *****
Password for user 2 is AnotherOne. This encrypts to fysar38. Another encryption leads to *****.

How would you check if the correct password is entered if everything encrypts towards ****?
Re: Encryption [message #301755 is a reply to message #301678] Thu, 21 February 2008 09:45 Go to previous messageGo to next message
Jayu
Messages: 14
Registered: August 2007
Location: India
Junior Member
Hi Frank,

Thanks for the reply...Then According to you its impossible to have 2nd level of encryption in DB side in such a way that it stores asterisk or hash(* or #) in the database.

Please suggest if any other approaches are there..

Thanks

Regards
Jayateerth
Re: Encryption [message #301758 is a reply to message #301635] Thu, 21 February 2008 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please suggest if any other approaches are there..
What business problem are you really trying to solve
& how would an independent observer know when it has been solved?
Re: Encryption [message #301762 is a reply to message #301635] Thu, 21 February 2008 10:05 Go to previous messageGo to next message
Jayu
Messages: 14
Registered: August 2007
Location: India
Junior Member
Hi,
Could you please elaborate on this please...

thanks
Encryption1 [message #301836 is a reply to message #301635] Thu, 21 February 2008 23:41 Go to previous messageGo to next message
Jayu
Messages: 14
Registered: August 2007
Location: India
Junior Member
Hi,

Is it possible in Oracle database to display astersik or hash symbol in one Column(say password) of the table??Presntly i am storing password in encrypted form but i want to show it as * or # in column of the table.

Thanks

Regards
Jayateerth
Re: Encryption1 [message #301842 is a reply to message #301836] Fri, 22 February 2008 00:04 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Don't start a new thread; continue in your old thread if the subject does not change.
If you are asking if it is possible to _store_ the encrypted data as asterisks, then the answer is No.

Answer anacedents question: what business problem are you trying to solve? If you answer that, we might come up with a reasonable solution.
Previous Topic: Formatting a SQL Query
Next Topic: commit or rollback
Goto Forum:
  


Current Time: Thu Feb 06 19:46:31 CST 2025