Just a small techtip
Sometimes you want to export table data. SQLDeveloper can help you with that with a few formats which are built-in and are callable via a simple hint within your SQL statement.
Say for example you have an employee table and want to export that data towards Excel via a CSV-file. The only action this takes is writing a SQL statement and adding the hint /*csv*/ to it. When you execute the statement as a script (hotkey F5) SQLDeveloper will export your data as CSV.
Example:
If we execute the following statement
SELECT /*csv*/ * FROM employee; We get
With this trick we can get all sorts of formats:
| Format code | Will give you |
|---|---|
| csv / delimited | CSV output (as shown in the example) |
| xml | XML output |
| html | HTML output |
| insert | An insert script |
| loader | Data in a loader file format |
| fixed | Fixed width data |
| text | Plain text format (concatenates everything) |
This might make your life easier when you need to quickly export data