Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Oracle encryption/decryption

Oracle encryption/decryption

Scheduled Pinned Locked Moved Database
oraclesecurityhelpquestion
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    StanlyJose
    wrote on last edited by
    #1

    we can get an encrypted text by using the below keyword DBMS_UTILITY.GET_HASH_VALUE in oracle I need to decript the particular string passed to this keyword for Eg: SELECT LTRIM (TO_CHAR ( DBMS_UTILITY.GET_HASH_VALUE ( 'ADMINISTRATOR',2,1048576))) FROM dual; this will return the encrypted text of 'ADMINISTRATOR' as 121216 But to get the Decryption of that 121216 as 'ADMINISTRATOR'.. is there any keyword used in oracle?? Please help me out.. Thanks in advance..

    Stanly.S

    L D 2 Replies Last reply
    0
    • S StanlyJose

      we can get an encrypted text by using the below keyword DBMS_UTILITY.GET_HASH_VALUE in oracle I need to decript the particular string passed to this keyword for Eg: SELECT LTRIM (TO_CHAR ( DBMS_UTILITY.GET_HASH_VALUE ( 'ADMINISTRATOR',2,1048576))) FROM dual; this will return the encrypted text of 'ADMINISTRATOR' as 121216 But to get the Decryption of that 121216 as 'ADMINISTRATOR'.. is there any keyword used in oracle?? Please help me out.. Thanks in advance..

      Stanly.S

      L Offline
      L Offline
      Luc Pattyn
      wrote on last edited by
      #2

      Hashing is not encryption, hashing is a reduction in size, somewhat like an executive summary; it implies throwing away information, hence a one-way operation. A common practice is to hash passwords and store the result, not the password itself. To check an incoming password, calculate its hash, and compare against the expected hash. No way to retrieve the password, it isn't there at all. :)

      Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


      Getting an article published on CodeProject now is hard and not sufficiently rewarded.


      1 Reply Last reply
      0
      • S StanlyJose

        we can get an encrypted text by using the below keyword DBMS_UTILITY.GET_HASH_VALUE in oracle I need to decript the particular string passed to this keyword for Eg: SELECT LTRIM (TO_CHAR ( DBMS_UTILITY.GET_HASH_VALUE ( 'ADMINISTRATOR',2,1048576))) FROM dual; this will return the encrypted text of 'ADMINISTRATOR' as 121216 But to get the Decryption of that 121216 as 'ADMINISTRATOR'.. is there any keyword used in oracle?? Please help me out.. Thanks in advance..

        Stanly.S

        D Offline
        D Offline
        Don Burton
        wrote on last edited by
        #3

        Have you considered DBMS_CRYPTO? Here's the link: http://www.oracle.com/technology/oramag/oracle/05-jan/o15security.html[^]

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups