title: Hi, i'm using spool for exporting 6 millions records, is query executes once or till end of last record
body: <p>A view returns 6 millions records.
  Earlier i used to export with sql developer(right click and export, it takes more than 2hr), but my senior said that, if do like this query will get executes every 500 rows. so we are getting warnings from DBA(long running queries). </p>
  
  <p>when searching internet i found that spooling works better for exporting. So i have doubt,In spooling is query executes once &amp; start exporting or it executes for till last row exporting.</p>