SQL Worksheet Preparation

Follow these steps:

  1. Select Tools>Preferences. Expand Database and go to Worksheet.

  2. Change the maximum number of rows to print in a script to 50000.

    Set the default path for scripts by browsing to SQLDevHome\sqldeveloper\dataminer\scripts, where SQLDevHome is the directory where you installed SQL Developer.

    Click OK.

  3. Right-click the administrative connection and select Open SQL Worksheet.

  4. Login using the administrative password.

  5. SQL Worksheet opens. For help with SQL Worksheet, go to the tab where the worksheet opened and press F1.