title: I want to generate a unique id in Oracle, it contains alphanumerics and length is 9-digits.please help me out
body: <p>I want to generate a unique id in Oracle, it contains alphanumerics and length is 9-digits.</p>
  
  <p>I tried,</p>
  
  <p>==> select substr(sys_guid(),5,9) guid from dual;</p>
  
  <p>will it have the unique nature?
  please anyone help me out.</p>
  
  <p>Thank u.</p>