TOAD® Handbook, Second Edition

8. Exporting Table Data

While TOAD may offer hundreds of features and capabilities, we realize that just three are used most frequently by the typical user: simple data browsing (see Chapter 2’s coverage of the Schema Browser), basic queries (see Chapter 3’s coverage of the Editor), and exporting data for use in other tools or databases. In fact, people “move” data more often than they realize—and that’s why this chapter on exporting data is important. TOAD makes data extraction from your Oracle tables and views a very simple process. With TOAD, you can easily move data to wherever you need to work on it. Thus, no matter whether you need the data in Microsoft Excel, Access, text files in numerous formats, or even XML, TOAD can quickly perform ...