How do I download a query result from Workbench?

How do I download results from Workbench?

To export data from Workbench, you need to opt for Bulk CSV in the “View As” options and run your query. Once it has run, you can download the query results by clicking on the download icon next to the Batch ID.

How do I export a SQL Workbench query?

Either select both statements in the editor and choose SQL → Execute selected, or make the two statements the only statements in the editor and choose SQL → Execute all. You can also export the result of a SELECT statement, by selecting the statement in the editor, and then choose SQL → Export query result.

How do I export a query result?

Steps to export query results to CSV in SQL Developer1Step 1: Run your query. Firstly, you'll need to run your query in SQL Developer. ... 2Step 2: Open the Export Wizard. ... 3Step 3: Select the CSV format and the location to export your file. ... 4Step 4: Export query results to CSV.

How do I export the query results from the developer console?

Right-click on the query result and select Inspect.1Look for the table tag, then do "Copy element".2Open Excel and Paste to get the result.