How to export the table data into a CSV file from Toad.
Export Database Table Data into CSV File Using Toad
I am using the Oracle database, and the table is customers from SH schema, to explain this example.
Open Toad and connect to the database.
Then click on the menu Database > Editor, to open the SQL editor window.
In SQL editor window, type your SQL query and press Ctrl+Enter to execute and get the results in a grid. Below is an example of an SQL query.
WHERE country_id = '52775' AND cust_valid = 'A';
4. Then right-click on the Grid in Toad and from the shortcut menu select the Export Dataset option.
5. In the Export Data window, select the options as shown in below image to export the data into CSV file from Toad. Select the option Delimited Text from the Export Format drop-down. Specify the file location and name in File field. Specify the delimiter and click OK to export.
Check your file location for the generated CSV file.