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
Before you export results from the SQL Results view, you must run
a routine or an SQL query.
About this task
To export results from the SQL Results view:
- Right-click anywhere in the Result tab, and select or If you do not see the Results tab, your database action did not return
any results.
- 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.
- 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.