Export Dataset

The Export Dataset button starts the Export Dataset wizard (see Figure 5.12). You can also access this option via a right-click on the data grid. The data and columns that appear in the data grid will be exported to one of a number of available formats. The order of the data and any applied filters will also be followed. In other words, you can use the View/Edit Query button to display the SQL that Toad will pass to this wizard.

Image

FIGURE 5.12 Export Dataset wizard

You can save data in the following formats:

Image Access Database File ...

Get Toad for Oracle Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.