title: What is the difference between connect by level and connect by prior in oracle?
body: <p>Plz any one explain me about "connect by level" and "connect by prior" in oracle with basic example..</p>
  
  <p>qn 1)
  select to_date('&amp;fromdate','DD-MM-YYYY') + level -1
  from dual
  connect by level&lt;=
  to_date('&amp;todate','DD-MM-YYYY')-to_date('&amp;fromdate','DD-MM-YYYY')+1;</p>
  
  <p>qn 2)
  Plz explain me about connect by prior with a basic query.</p>
  
  <p>Thanks in advance :)</p>