title: Export table / view to .csv in batches of x number of rows
body: <p>The server is an <strong>Oracle Database 12c Enterprise Edition Release 12.1.0.2.0</strong></p>
  <p>I have about many tables / views of varying size (1 to 25 million rows x 5 to 100 columns).</p>
  <p>I can only access the server through Oracle SQL Developer.</p>
  <p>Due to limitation on the server hardware I'm not able to extract all rows in a single export using the &quot;Export Wizard&quot; so instead I'm splitting every table up into 'chunks' of 1 million using the following simply query:</p>
  <pre><code>SELECT * 
  FROM [my_table]
  OFFSET [rows_extracted_already] ROWS
  FETCH NEXT 1000000 ROWS ONLY;
  </code></pre>
  <p>Then I get a Query Result -&gt; Right-click -&gt; Export -&gt; Use the Export Wizard -&gt; Repeat.</p>
  <p>This is taking a LONG time and I cannot seem to find a simple way to do this.</p>