Can data be imported directly from a database with SQL Loader? (4280028)

Can I use SQL Loader to import data directly from a database table and not from a data file?

You can generate a SQL Loader control file with the data in it.

1. Run your query in the Editor

2. When the Data Grid comes back with the result, right click in the Data Grid and choose Export Dataset

3. In the Export Format, choose SQL Loader

4. This will generate a SQL Loader control file with the data in the control file

5. Run Database | Import | SQL Loader and choose to use the control file you created above