Exporting results from the SQL Results view to a file

After you perform an action on a database, you can export the results to a file on the file system. Several file formats are supported, including *.html and *.csv, so that you can view the results in external tools such as spreadsheets. This method can be useful if you want to more easily share results information with team members who do not have the workbench installed.

Before you begin

Run a routine or an SQL query.

Procedure

To export results from the SQL Results view:

  1. Right-click anywhere in the Results tab, and select Export > Current Result or Export > All Results If you do not see the Results tab, your database action did not return any results.
  2. Select a file folder in which to save the result set, enter a file name and file type, and specify export options. If you do not specify a file location, the file is saved to the <installation>\eclipse directory.
  3. Click Finish.

Results

The result set is exported to the file that you specified. You can open the file from the file system using the appropriate external program.

Feedback