Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

generate a unique number from a string

muttleychessJun 12 2020 — edited Jul 31 2020

Hi

Can I use the ora_hash function to generate a unique key(number) from the concatenation of two strings?, 

  Because I need to generate a unique  number
   I'm afraid that another string will generate an equal number, using this function

Is threre other way to do it ?

using
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0    Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
 



This post has been answered by mathguy on Jun 12 2020
Jump to Answer



  

    
    

      
Comments

      

    

    

  

  

  



        

  

    
    

      
Post Details

      

    

    

  

  


  
    
    
    
      
Added on Jun 12 2020
      
      
      
    
  
  
    
    
    
      
                           3 comments
      
      
      
    
  
  
    
    
    
      
                       4,313 views