Home » SQL & PL/SQL » SQL & PL/SQL » select dump
select dump [message #251872] Tue, 17 July 2007 01:07 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

there is a select statment in oracle

select dump('hello') from dual;




which returns :
Typ=96 Len=5: 104,101,108,108,111


is there anyway to make the opposite of that i have the result and i would like to get the source
is there any command like "undump"

thanks for everyone helped and helping me
Re: select dump [message #251874 is a reply to message #251872] Tue, 17 July 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is possible, you just have to reverse engineer the Oracle codes.
But can you tell me what is the need?

Regards
Michel
Re: select dump [message #251877 is a reply to message #251872] Tue, 17 July 2007 01:16 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

my need:
i have password incrypted in this form and i want to decrypt it
Re: select dump [message #251879 is a reply to message #251877] Tue, 17 July 2007 01:20 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And the "encryption" is just a dump?

MHE
Re: select dump [message #251880 is a reply to message #251872] Tue, 17 July 2007 01:20 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

no there is another level of encryption
Re: select dump [message #251881 is a reply to message #251880] Tue, 17 July 2007 01:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
There you go. Unless you know the way it is encrypted, how are you planning to decrypt the text? Brute force?

MHE
Re: select dump [message #251901 is a reply to message #251880] Tue, 17 July 2007 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is really not clear what you have and what you want.
Post an example.
But I don't see the purpose of "dump" (or "undump") function.

Regards
Michel
Re: select dump [message #251904 is a reply to message #251872] Tue, 17 July 2007 02:17 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

dear sir,
my first post explains and shows and examples
Re: select dump [message #251908 is a reply to message #251904] Tue, 17 July 2007 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So my first answer explains what you can do.

Regards
Michel
Re: select dump [message #251963 is a reply to message #251872] Tue, 17 July 2007 10:06 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
I've never heard of a valid business reason to be decrypting anyone's password. That is the whole point of password encryption.

Whoever would have the privs to decrypt it, should also have the privs to reset the password and/or disable the account and/or obsolete the user in whatever application they are using, etc etc.



Previous Topic: Regarding FORALL ...DELETE
Next Topic: Finding second highest salary
Goto Forum:
  


Current Time: Thu Dec 08 14:47:31 CST 2016

Total time taken to generate the page: 0.11108 seconds