Home > Dialog Boxes for Creating/E... > Export Table Data
This dialog box is displayed when you right-click a table name, a table data display, a SQL Worksheet result set, or report output, and select Export and then an export format. You can export some or all of the data to a file or to the system clipboard. To restrict the output to specified columns, use the Columns tab. To restrict the output based on a WHERE clause condition, use the Where tab.
Format tab
Format: Determines the format of entries written in the specified output file: CSV for comma-separated values including a header row for column identifiers, Fixed for a file where records are the same byte length, HTML for an HTML file containing a table with the data, Insert for SQL INSERT statements, Loader for a SQL*Loader control file, Text for a text file, TTBulkCP for a data files to be used with the TimesTen ttbulkcp command line utility, XLS for a Microsoft Excel worksheet, or XML for XML tags and data.
For exporting large tables to Microsoft Excel files:
If you encounter problems, try adding the following line to the sqldeveloper.conf file to increase heap size and then restarting SQL Developer: AddVMOption -Xmx1024M
If the number of table rows exceeds 65,536, SQL Developer writes the rows to multiple worksheets within the .xls file.
Output: File writes the output to a file that you specify; Clipboard places the output on the system clipboard, so that you can paste it into a file, a command line, or other location appropriate for the format.
File: If the output is to a file, click Browse to select the directory or folder and to specify the file name and extension. The file path is then placed in the File box. (The default file path for export operations is specified in the SQL Developer user preferences for Database.) Standard file extensions include .sql for Insert format, .xls for Microsoft Excel format, .xml for XML format, .ctl for SQL LOADER format, and .csv for CSV format.
Columns tab
You can specify whether the output should include data from all columns or just from the checked columns. (Note: For CLOB columns, only the first 32 KB of any CLOB is exported.)
Where tab
You can restrict the output by entering a valid WHERE clause for a query on the table, without the WHERE keyword. For example, to restrict the exported data to rows where a column named RATING contains a value greater than 5, specify: rating > 5