title: I have one source table whose data looks like
body: <pre><code>**COLOR**   **TIMES**
  ORANGE         1
  RED            2
  BLACK          3
  YELLOW         4
  </code></pre>
  
  <p>But I need Data to be display in below format :-</p>
  
  <pre><code>**COLOR**   **TIMES**
  ORANGE          1
  RED             1
  RED             1
  BLACK           1
  BLACK           1
  BLACK           1
  YELLOW          1
  YELLOW          1
  YELLOW          1
  YELLOW          1
  </code></pre>
  
  <p>Please suggest me the query in oracle SQL</p>