Export to Excel
The export function for query result is not so obvious for developers to find out. In this post, I will show how to export query result as a Excel file.
Show Query Result as Grid
To show the query result in a grid table, you have to use F9 or Ctrl+Enter to format query result in grid.
Right Click Mouse and Export
Move your cursor over anywhere on the grid and right click the mouse, you will see Export option.
Export Entire Table
If the data you want to export is a table, not a query result, you can directly right-click on the table and select Export in the menu.
Select Export Format
SQL Developer showed Export Wizard window for interaction. Although there're many export types for us to select, we chose Excel format in this case.
Select Text Encoding
I chose UTF-8 in order to match the database encoding.
Customize Filename
If you want to change the path, you can click Browse to navigate and choose a right directory to place.
Review Export Job Before Executing
You can expand all options to see the content of the export job.
Check Content of Excel File
We open the Excel file in an application, so they can be viewed its content below.
That's it!
Next, we can restore the Excel data back into table by importing data in SQL Developer whenever needed.