In Oracle SQL Developer, can I export all table column details as CSV files without clicking on each table and then exporting?
I want to export all of information from the "Columns" tab for each table in an Oracle database. I know I can do this manually (click on each table, go to the Columns tab, right click, click "Export", and create a CSV file - included in case there is a better way to do this!), but is there any way to do this without having to go to each table individually? Thank you!
Edit: I forgot to mention that I want to select tables under a specific owner.
If I understood you correctly, you'd just go to Tools menu and choose Database export. Follow the wizard, for example
- choose connection
- don't export DDL
- export data
- format insert statements
- single file
- set target file location and name
On the next screen choose objects to export (you'd probably want to exclude all but tables).
The rest is <Next ... Next> and - that's all. File contents is displayed in SQL Developer, and you'll find it in target folder as well.
Step-by-step demo:
