Using SQL Developer, you can also import data into tables. The most common approach is running a well-formed (syntactically correct) script file of INSERT statements. The Import Data wizard is available from the context menu of existing tables and on the context menu of the Tables node, where you can import data and create the table in a one-step operation. The import wizard allows you to import data from a delimited format file or a Microsoft Excel XLS file. In this section, we'll look at three of the supported SQL Developer Data Export file formats.
When importing data into tables from a file, the structure of the file, whether it is SQL or XLS, determines how the import works. For an SQL script file of insert statements, you only need to run the script from the SQL Worksheet, or open the file in the SQL Worksheet, and then run it against a particular schema to import the data.
In the example in the preceding screenshot, the file is open...