How to export data with Oracle SQL Developer?

sql oracle oracle-sqldeveloper

How to export Oracle DB data using SQL Developer? I need all data, tables, constraints, structure and so on.


In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. It's pretty straightforward from there.

There is a tutorial on the OTN site. Find it here.


In version 3, they changed "export" to "unload". It still functions more or less the same.


If, at some point, you only need to export a single result set, just right click "on the data" (any column of any row) there you will find an export option. The wizard exports the complete result set regardless of what you selected

Related

The proper way of forcing a 32-bit compile using CMake
Blurring an image via CSS?
ReactJS: onClick handler not firing when placed on a child component
How to trap ERR when using 'set -e' in Bash
How to debug RESTful services? [closed]
Run pdflatex quietly [closed]
What is the meaning of # in URL and how can I use that?
What's the difference in using toString() compared to JSON.stringify()?
Swift: Class Prefix Needed?
ASP.NET 5 Authorize against two or more policies (OR-combined policy)
How to print a Groovy variable in Jenkins?
ConstraintLayout, when constraint dependent view is gone, the layout view behave weirdly