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 text field of "Max Rows to print in a script" field and click on OK.