Exporting Query Result Using SQL Developer

SQL Developer not only lets you view the query result in your screen but also lets you export and save the result in a file format that you like. Sometime, you will be asked to send the result back to the requester or your boss in an excel, text or xml file format. SQL Developer has covered for you. There are several ways to export the result to your desired file format. Here, I will present you guys with the two ways that I am familiar using SQL Developer.
Let's begin!

1. Run your Query
2. Right click on your result set 
3. You will see a window as shown below
4. 
5. Select the file format from the drop down list.
6. Select the location where you want to save it.
7. Click Next. 
8. Go to the saved location,verify the file format and the output of a file.

There's also another quick way to achieve the same thing.  You must run your query as SCRIPT in SQL developer. This does not work with SQLPlus!!

-- Displays the output on cvs file

select /*csv*/ * from dba_users;

--Displays the output in HTML format

select /*delimited*/ * from dba_users;

--Displays the output in XML

select /*xml*/  * from dba_users;

-- Generates INSERT statements.

select /*insert*/ * from dba_users;

These are just the examples, you have more file formats you can save your query result into. Isn't the sleek? I will let you explore them and comment below if you want to share with others.