Prerequisites

For the SQL developer you must have:

  • SQL Developer version 4.2.x.x.x
  • SQL Developer build 17.089.1709

Change the maximum number of rows written to the output file. To do this:

  1. Navigate to Tools > Preferences. Open the Preferences dialogue box.
  2. Drill down to Databases > Worksheets.
  3. Clear default value in the Max Rows to print in a script field and click OK.