title: Return more than 50 rows in Oracle Live SQL
body: <p>Regarding the Oracle Live SQL online environment (<a href="https://livesql.oracle.com/" rel="nofollow noreferrer">https://livesql.oracle.com/</a>):</p>
  <p>When I run a query, only 50 rows are returned by default.</p>
  <p>Is there a way to return more than 50 rows?</p>
  <hr />
  <p>Example session: <a href="https://livesql.oracle.com/apex/livesql/s/nmwyv5cu5vo4p9vofwjsasemh" rel="nofollow noreferrer">https://livesql.oracle.com/apex/livesql/s/nmwyv5cu5vo4p9vofwjsasemh</a></p>
  <p><a href="https://i.stack.imgur.com/smJM8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/smJM8.png" alt="enter image description here" /></a></p>
  <hr />
  <p>Source script: <a href="https://stackoverflow.com/a/72621332/5576771">https://stackoverflow.com/a/72621332/5576771</a></p>
  <pre><code>--This query should return 220 rows.
  with dimension as (
      select 0 as point from dual
        union all 
      select level
      from dual
      connect by level &lt;= 10
  ), points as (
      select 
        a.point as startpoint, 
        b.point as endpoint,
        c.point as fixed
      from dimension a
      cross join dimension b
      cross join dimension c
      where b.point - a.point = 1
  )
  select
    startpoint as startpoint_x,
    fixed as startpoint_y,
    endpoint as endpoint_x,
    fixed as endpoint_y
  from points
    union all
  select
    fixed as startpoint_x,
    startpoint as startpoint_y,
    fixed as endpoint_x,
    endpoint as endpoint_y
  from points
  order by startpoint_y, endpoint_y, startpoint_x, endpoint_x
  </code></pre>