title: PLSQL generate random integer
body: <p>In Oracle Sql developer 11g, how do I generate a random integer and assign it to a variable? This is what I've tried so far:</p>
  
  <pre><code>S_TB := SELECT dbms_random.value(1,10) num FROM dual;
  </code></pre>
  
  <p>With this code I got error: </p>
  
  <pre><code>S_TB := SELECT dbms_random.value(1,10) num FROM dual
  Error report -
  Unknown Command
  </code></pre>
  
  <p>What is the proper way to solve my issue?</p>