Exporting Data

Export data to other formats

You can export data to other formats using the Data Export Wizard. The appearance of the wizard can differ depending on a product you use.

To export data:

  1. Open the Data Export wizard by doing either of these actions:
    • Click Export Data on the Data Pump tab of Start Page.
    • In Database Explorer, right-click a table or a view (or CTRL+click several tables and/or views) you want to export data from and select Data Export icon Export Data on the shortcut menu.
    • Right-click data grid and choose Export Data on the shortcut menu, or click Data Export icon Export Data on the Data Editor window toolbar.
    • Click Data Export icon Export Data on the Database menu.

    Note

    dbForge Studio for Oracle comes with Paginal Mode enabled by default, limiting data selection to the first 1000 records. To export more records, disable the Paginal Mode and press Ctrl+End to fetch all the selected data at once. Then, click Data Export icon Export Data at the top of the grid to open the Data Export Wizard.

  2. On the Export format tab, select an export format or load export options from a template file if you saved them previously and click Next.

  3. On the Source tab, select a required Oracle server connection, a database, table(s), view(s), which you want to export, and then click Next.

    Note

    If you opened the wizard from the data grid, the Source tab would allow to specify only a name and a path of the destination file (the one where the exported data will be saved).

  4. On the Options page, set additional settings for the selected export format and click Next.
  5. Select the columns to be exported and click Next. (For CSV, HTML, PDF, RTF, and Text export formats, select formats of data representation, e.g., integer, date, time, etc. For Excel and Excel 2007 formats, the field is editable only for binary columns and includes only two data types (HexString and String) in the drop-down list).
  6. Select the rows to be exported. You can export all rows, only selected in the grid ones, or a specified range.
  7. Specify how the application should behave when an error is encountered.
  8. (Optional) To export options to a template file for future usage, click Save Template and specify a path and a name of the template file.
  9. Define how dbForge Studio for Oracle should handle errors during export and whether to write a log file.
  10. To proceed with the data export, click Export and see the result of export process.
  11. Select whether to open the exported file or result folder, and click Finish. The data export process is finished.

Filtered data export

There is a filter in the Data Export wizard window.

Data Export wizard

If you want to filter data, use the required column filter. To do this, firstly write a whole data query using the SELECT * FROM statement. Click Execute to implement the query. Then, on the required column name, click the filter icon. In the drop-down list, choose the item to filter by. Right-click the filtered grid, and select Export Data to call the Data Export wizard.

Another and the most reliable way to export filtered data is to filter it directly in the query. Execute the SELECT * FROM statement with the WHERE condition, where you can specify the required filter. And then implement already filtered data export with the Data Export wizard, calling it from the filtered grid shortcut menu.

Filter data in the SELECT statement using the WHERE condition

Follow the Data Export wizard steps, click Export. If the data export is finished successfully, the Data export complete message appears.