title: How to use spool in Plsql developer
body: <p>I was wondering if we could use <code>spool</code> in Plsql developer. I am currently running a query in plsql developer which is resulting in a result set of 1 million rows. I need to export that data to an excel file but when I am selecting the columns and right clicking on the data to copy it to the excel file, it copies only 10 or 11 rows, To load all the rows, I need to press the downward arrow in the image <a href="https://i.stack.imgur.com/HysbR.png" rel="nofollow noreferrer">here</a></p>
  
  <p>and it takes so much time to load. I was wondering if there is any easy way I could export my huge amount of data directly to an excel file in plsql developer?</p>