title: generate Multiple UUID Oracle
body: <p>Oracle:-
  I have around 850 records in an table, that need to be assigned UUID.</p>
  
  <p>I am using the following query.</p>
  
  <pre><code>select substr(sys_guid(),1,3)||'-'||
            substr(sys_guid(),4,4)||'-'||
            substr(sys_guid(),8,4)||'-'||
            substr(sys_guid(),13)
  from (select sys_guid() as mygid from dual)
  </code></pre>
  
  <p>I need to generate multiple/850 records in one go.
  Any suggestions ?
  Should I loop over?</p>