Question: how to export all data from oracle sql developer?
Answer: Step 1: Run your query. To start, you'll need to run your query in SQL Developer. ... 
Step 2: Open the Export Wizard. ... 
Step 3: Select the Excel format and the location to export your file. ... 
Step 4: Export the query output to Excel.