title: Oracle Iterate query result without insert
body: <p>I have the following table like below</p>
  
  <p><a href="https://i.stack.imgur.com/BEYQK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BEYQK.png" alt="enter image description here"></a></p>
  
  <p>And the result I expected below, depend on the date diff (ex. 2020/3/27 - 2020/3/20 =7) and extend the result. Does it possible without use insert to the internal table and extend the table by the original. Because of the privilege limitation.</p>
  
  <p><a href="https://i.stack.imgur.com/jIti3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jIti3.png" alt="enter image description here"></a></p>